A long time ago in a galaxy far, far away Oracle decided to treat '' as
identical to NULL.
Coming closer to the present, DBD::Oracle (by default) trims trailing spaces
from strings being used in placeholders. Fortunately this behavior can be
modified by adding '$dbh->{ora_ph_type} = 5;' (or 96 or 97) before you
prepare the statement of interest.
Unfortunately, no one (including me) has gotten around to documenting this
anywhere except in DBD-Oracle-1.12/Changes.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 11:21
Subject: RE: Inserting spaces into a NOT NULL column
Unfortunately changing the table to allow nulls isn't an option.
It takes something like an act of congress to get things changed around
here so that option is out. I actually tried this tactic but was shot
down by the powers that be as something 'not worth the cost to
implement'.
I'm not sure why all spaces would be considered null by DBI, it is a
value and has meaning in my system (I didn't design it and I can't
change it so spaces has no value).
I need some solution that will force DBI to read all spaces literally as
all spaces and not null while not making the field too big to fit in the
column.
