[Dbix-class] Inserting empty string into DATETIME field in MySQL
pwood at christianbook.com
Mon Oct 10 18:30:29 GMT 2011
I'm trying to insert an empty string into a datetime field in MySQL version 5.0.18, using DBIx::Class version 0.08120. This particular field is defined like so, within a call to 'add_columns':
data_type => "DATETIME",
default_value => undef,
is_nullable => 1,
size => 19,
If I provide a complete value for start_date (eg 2011-10-10 14:29:27), everything works fine. However, when I try to set it to the empty string (''), the value inserted in the database is '0000-00-00 00:00:00'. If I run an insert on the command-line mysql client, and provide the empty string as the value for that field, it properly sets an empty value in the database.
Is there something else I should be doing to properly insert an empty string into this column?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DBIx-Class