April 4, 2011 at 6:52 am
Hello,
I'm new here but I didn't find anything to solve my problem.
I have to insert a string into a NVARCHAR (max) column.
The string contains some characters which make som problems, if there is a trailing \ like "\lf" (backslash linefeed).
I get the string via socket, so I cannot affect the stream.
I want to buffer it into the database and read it after some time.
The read out string doesn't contain the \LF anymoore. :angry:
The valueslist of the ascii-chars causing the problem, is about 29 chars long.
(10,13,128,130...140,142,145...156,158,159)
Is there a general way to solve the Problem? (Database-Option or so)
Regards
Christian
April 4, 2011 at 7:32 am
freund (4/4/2011)
The read out string doesn't contain the \LF anymoore. :angry:
I hope I'm not offending anyone, but... have you checked this from SSMS? I'm sure you're aware that newline chars are not visible in SSMS grid results. Just checking that you didn't overlook it.
-- Gianluca Sartori
April 4, 2011 at 7:41 am
Hi,
no I didn't check it out of SSMS.
I know about the problem in the grid.
I checked it out of the programming surface.
Regards,
Christian
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply