Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
RE: How to Insert linefeed chatacter in a string
From: Zabach, Elke (elke.zabachsap.com)
Date: Fri Jun 02 2006 - 01:17:45 CDT
Derek M. A. Lee-Wo wrote:
> 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.
It is sometime astonishing for us, that customer uses LONG-columns and
want to handle them with string literals and scripts, where usually
values are not that long.
You are sure that you need LONG-column and that no VARCHAR-column would
But despite this, linefeed cannot be included with \n or the like.
Only if some kind of editor is able to fill in the linefeed-value,
string literals could work with this.
Otherwise there only will be the chance to use some programming tool as
SAP Labs Berlin
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb