On Fri, Aug 01, 2003 at 09:03:21AM -0500, Igor Korolev wrote:
> Actually, there are quite a few messages about this in the group
> archive. Just search for "NULL".
>
> You need to pass the third parameter -- {type => SQL_CHAR} to
> bind_param method (see DBI perldoc). Otherwise, the driver
> stripps out leading and trailing whitespace.
That's the right answer to the wrong question. The original poster was
inserting undef, and getting 'NULL' instead of NULL. Your answer is for
someone who is inserting ' ', and getting NULL instead of ' '.
Ronald
