in reply to Oracle DBI quote

What happens if you insert the empty string into the same type of field from sqlplus (Update: actually, I would expect the same results as demerphq's suggesstion above, but you never know)? If you get the same result, then its not DBI/DBD (maybe the empty string is interpreted as null in a char column?). If you get different results, then you could post a DBI trace to the DBI mailing list and ask for help there.

Replies are listed 'Best First'.
Re: Re: Oracle DBI quote
by Cine (Friar) on Oct 25, 2002 at 22:58 UTC
    It is a well known fact that Oracle (among others?) thinks that an empty string is NULL, so the problem resides in all tools which doesn't do anything special about it.
    However I do try to do something special about it. I use a string with only a single space and turn off ChopBlanks, but this is not working for some reason.

    T I M T O W T D I