Jan Hlavaty wrote:
> Franck CHANU wrote:
> > 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')
> >
>
> It would be nice if hex literals would work for this purpose,
> but they
> do not!
>
> 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...
We will discuss this suggestion.
> 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).
What kind of optimizer problems did you observe with multicolumn
indexes?
Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
