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]

Reply via email to