From: Zabach, Elke (elke.zabachsap.com)
Date: Fri Jun 02 2006 - 01:17:45 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

 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
be convenient?

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
you mentioned.

Elke
SAP Labs Berlin

> Thanks
> Derek
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=elke.zabachsap.com
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]