I have a table that inserts comments, the comments field it is defined as nvarchar(MAX), but in the ASP i need to define a max number of characters, what should that number be?
This is part of the insert statement for the note in the ASP page:
sp_addnote.Parameters.Append sp_addnote.CreateParameter("@comments", 200, 1,8000000,sp_addnote__comments)
I entered '8000000' as the max number of characters, but I imagine there is a better number to put there?
2. Also the SP is failing to accept Korean characters. I am not sure where to add the N' before the value that will be inserted so that it recognizes the Korean characters, here is the SP as I have it right now:
SET ANSI_NULLS OFF;
SET QUOTED_IDENTIFIER ON;
ALTER PROCEDURE [dbo].[add_notes]
INSERT INTO dbo.Casecomments
(@caseid, @visible, (N'@comments), @updatedby, @lastupdate, '0', @sectioncase, @firmid, @importance, @visibleemployer);
I added the N' in the values before the @comments parameter, but its failing, my syntax must be wrong ... or maybe it should not be there and should be in the line of the ASP ?
Without the N' the characters are converted into ???? characters.