Bjørn,
Aren't those semantics all host language based? I haven't been
working on Pro-X languages for a while, but I seem to recall that there were
language options (switches, directives) on how the comparisons were
done. Also, you could easily move the data from one data type to another
if needed. In fact, in the early days, I remember VARCHAR2 was also
blank-padded on output by default and trimmed when storing into the
database. Are you referring to more recent ANSI standards? I believe
you can still turn off the ANSI semantics if you want.
Marc.
|
Title: White space compression in Oracle
- Re: White space compression in Oracle Bjørn Engsig
- RE: White space compression in Oracle Ji, Richard
- RE: White space compression in Oracle Marc Perkowitz
- RE: White space compression in Oracle Jamadagni, Rajendra