Hi,
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 ?
Here is a sample ODBC TRACE :
PRODUCT : SAP DB C-PreComp Runtime
VERSION : 7.3.0
BUILD : 030-000-000-000
DATASOURCE: SAPARPE
SESSION : 1;
SQLMODE : INTERN
SERVERDB : ARPE
SERVERNODE: franckc
CONNECT "MELODIE " IDENTIFIED BY :A ISOLATION LEVEL 1
START : DATE : 2003-01-20 TIME : 0016:08:03
END : DATE : 2003-01-20 TIME : 0016:08:03
insert into test lib values ('a b')
PARSE : CMD :
mfIndex init : 1
PARSEID: OUTPUT: 00000154 00000201 23000000 01000000
START : DATE : 2003-01-20 TIME : 0016:08:28
END : DATE : 2003-01-20 TIME : 0016:08:28
insert into test lib values ('a b')
EXECUTE: CMD :
PARSEID: INPUT : 00000154 00000201 23000000 01000000
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-20 TIME : 0016:08:28
END : DATE : 2003-01-20 TIME : 0016:08:28
PARSEID: DROP : 00000154 00000201 23000000 01000000
START : DATE : 2003-01-20 TIME : 0016:08:29
END : DATE : 2003-01-20 TIME : 0016:08:29
SQCDROPPARSID
PARSEID: : 00000154 00000201 23000000 01000000
---
Franck CHANU
Responsable des projets Concerto
Arp�ge
T�l. 02 51 79 50 50
Fax. 02 51 79 50 51
44, boulevard des Pas Enchant�s
44230 Saint-S�bastien-sur-Loire
FRANCE
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
