Franck CHANU wrote:
> I'm testing SAP DB 7.3 on NT and i find it functionnaly good
> but I have
> one problem left : I can't insert CR or LF nor CR/LF in tables.
> Here is what I tried :
>
> create table test (lib varchar(255))
>
> insert into test lib values ('a
> b')
>
> insert into test lib values ('a'||chr(13)||chr(10)||'b') /* as in
> Oracle */
>
> the results are :
>
> a b
> a13 10 b
We don't no why anymore but in the past the kernel wasn't able to handle
CR, LF or TAB within strings.
So the odbc driver replaces every CR, LF and TAB with a Space.
We made some tests and didn't find any problems with this special characters.
So I think we changed this behaviour in one of the next releases.
In the meantime you could use the "chr()" function in the oracle mode.
Then your above example should work like expected.
Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
