It's LONG, so I think that is really a "LONG VARCHAR". Anyway, I ended up doing it via a loadercli script. In there, I can insert the EOLN character by simply putting a newline in the script where I want the character to appear.
Derek > Sorry, I did not read that you want to fill a LONG column. The method I > suggested only works > for VARCHAR/CHAR columns. Sorry, for LONG values there is no such way. > > Regards > Alexander Schröder > > -----Original Message----- > From: Schroeder, Alexander [mailto:[EMAIL PROTECTED] > Sent: Freitag, 2. Juni 2006 10:22 > To: Derek M. A. Lee-Wo; maxdb@lists.mysql.com > Subject: RE: How to Insert linefeed chatacter in a string > > 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] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
