Franck CHANU wrote:
It would be nice if hex literals would work for this purpose, but they do not!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')
If they worked, you could use 'Line1' || x'0d0a' || 'Line2' (for 8-bit charsets) or 'Line1' || x'000d000a' || 'Line2' (for unicode columns).
But they don't work. Could something be done about it SAP? Should be pretty simple change...
I'd need it to insert zeros or tabs between fields when creating indexes over multiple columns (bacause query optimizer seems to be unable to use multicolumn indexes correctly).
Jan
smime.p7s
Description: S/MIME Cryptographic Signature
