I'm coding a project, it uses MySQL(i), PostgreSQL, Oracle and MSSQL (SQL Server through ODBC).
Everything seems fine, except for a few errors.
It seems that MySQL 5+ throws an error if you insert let's say 500 characters long string into a varchar(255), but MySQL 4 will automatically truncate it? How can I force MySQL to do this autotruncating?
Does this have something to do with SQL modes?
http://dev.mysql.com/doc/refman/5.0/en/ ... -mode.html
Does setting it to Strict mode provide any help?
Thanks for your answers