=>The question now is: how is the column defined in the MySql database ? Could you provide the SQL for the table definition ?
MySQL 5.1 seems to understand and accept that value, this SQL is generated from the MySQL 5.1 query tool and executes fine. I did not create this table in MySQL initially but used a SQL script exported from SQL Server. DROP TABLE IF EXISTS `testdb`.`cireport`; CREATE TABLE `testdb`.`cireport` ( `id` int(11) NOT NULL default '0', `startdate` datetime default '0000-00-00 00:00:00', `enddate` datetime default '0000-00-00 00:00:00', `employee` int(11) default '0', `lead` int(11) default '0', `rating` int(11) default '0', `type` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; <vignesh/> *************************************************************************************************** The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. This email does not constitute any commitment from Cordys Holding BV or any of its subsidiaries except when expressly agreed in a written agreement between the intended recipient and Cordys Holding BV or its subsidiaries. ***************************************************************************************************
