  | | | How to Insert linefeed chatacter in a string: Inserting Linefeed into Stri | How to Insert linefeed chatacter in a string: Inserting Linefeed into Stri 2006-08-16 - By Michael Neuber
Back I am looking for a solution to following problem: I wanted to insert a string to the a maxDB (7.5.00.34) containing the a CRLF (Carriage Return Line feed, here marked as \n) :
insert into testtable ( stringattribute) values('ABCDE \n\\www.abc.de')
Had similar probs as described in the thread RE: How to Insert linefeed chatacter in a string - Derek M. A. Lee-Wo, June 2 2006 2:18pm
Though, in my case ist really a VARCHAR attribute, and I managed to to it with a CRLF character in many cases.
However, when the next chars are 2 slashes on the new line, the CLI obviously thinks there's the end of the previous command, though I am still writing a string ( closing ' has not yet come !)
Is there a way to make clear to the CLI that I am still writing a string content and that the new line's // belong to that content?
Regards M.Neuber
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
 |