Auer, Wolfgang schrieb:
Hello,
Do you depend on the CLI programm. You could use SQL Studio to do the
insert.
Regards
Wolfgang
-----Original Message-----
From: Michael Neuber [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 16. August 2006 16:18
To: maxdb@lists.mysql.com
Subject: RE: How to Insert linefeed chatacter in a string: Inserting
Linefeed into String with following //
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
Hm... I'd say I indeed depend on CLI,
it's script based mass data upload what I am doing here.
Experience tells that SQL Studio is not the right thing to use then..
;-)
But...
I found a solution, not toooo nice, but a easily feasable work around:
Its just cutting the string which makes CLI somehow blind for the //.
IOW:
insert into testtable ( stringattribute) values('ABCDE
' ||'//www.abc.de')
-Note that there is a CRLF between the two lines.-
This works.
(BTW: Made a mistake in the first mail, its //www.... not \\www....)
Thanks for replying anyway. :-)
M.Neuber
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
