Hi,
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
>
> I tried via ODBC and SQLStudio end I got the same results.
> I looked in docs and archives but the only thing I found was that
> someone had the same kind of problem with php and linux, without any
> solution.
>
> Can someone help ?
>
if you're looking for some interface doing it for you I could offer
RepMan (repmcli).
Running a script like this
create table test (lib varchar(255))
//
insert into test lib values ('a
b')
//
insert into test lib values ('c
c')
will insert 'a\nb' and c\nd.
HTH.
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
