MySQL Forums
Forum List  »  Microsoft SQL Server

Can't insert empty dates as in Sql Server ?
Posted by: m f
Date: January 18, 2006 04:06AM

Hello,

We are migrating a huge software to MySql 5.0. It currently uses a SqlServer 2000 database. A lot of requests were badly written and sometimes insert dates as an empty string '' (not a null, an empty string='').

Empty values are not accepted for date columns by MySql. We tryied several option of sqlmode, but could not manage to make MySql accept these empty dates or transform them as NULL.

Modifying all these requests would be a huge job, so we can't go in this way. The only solution would be to have MySql behave like Sql Server.

Any idea ?
Thank you for your help.

Mitch.

Options: ReplyQuote


Subject
Written By
Posted
Can't insert empty dates as in Sql Server ?
m f
January 18, 2006 04:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.