"ChopBlanks" (boolean, inherited)
This attribute can be used to control the trimming of trailing
space characters from fixed width character (CHAR) fields. No
other field types are affected, even where field values have
trailing spaces.
**WHY** only from fixed width character fields, and not from varchar2 fields ?
:((((
We've got a multidatabase environment, in which we try *very* hard not to get
NULL fields - ever -. This means we have to insert triggers in Oracle to
inhibit it's fu**ing annoying behaviour of translating empty varchar fields to
NULL. (If I insert an empty string I expect an empty string, and not a null
field!)
The triggers translate all empty strings to a string with just a single space
in it on insert and update.
--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using perl-5.6.1, 5.7.1 & 630 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3,
WinNT 4, Win2K pro & WinCE 2.11 often with Tk800.022 &/| DBD-Unify
ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/H/HM/HMBRAND/
