Hello Derek,
use something like
INSERT INTO ABCDE VALUES ('ABC' || ASCII(x'0A') || 'DEF')
(which obviously looks so strange that it can only be suggested if there's
really no other alternative).
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
-----Original Message-----
From: Derek M. A. Lee-Wo [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 1. Juni 2006 21:52
To: maxdb@lists.mysql.com
Subject: How to Insert linefeed chatacter in a string
I have a "LONG" column and I wish to insert a LF character in it.
I tried:
INSERT INTO .... ('line1\nline2\nline3')
but it inserts the characters '\' and '\n'
How can I get an actual LF character (hex 0A, octal 012) in a string?
In another type of database, I could do:
INSERT INTO .... ('line1\012line2\012line3')
but that doesn't work for SAPDB.
I know I can do it programatically via Java, but I'd like to create a
script that I execute via dbmcli.
Thanks
Derek
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
