MySQL Forums
Forum List  »  Quality Assurance

Truncating comments using STRICT_TRANS_TABLES
Posted by: Mr Chaiyaphum
Date: June 22, 2012 07:42AM

We encounter an odd problem over here. We use the Strict_Trans_Tables setting in our MySql environment as following:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Using this setting causes a create table statement, followed by inserting records in this table to fail. What happens is that a comment in a certain field is truncated to only 255 positions. Because we have records with comments upto 500 positions, this option causes data loss. This is unacceptable. If we disable the option, however, the same thing is still happening!
Has anybody any idea how to solve this problem? Is there another setting in the MySql environment we need to use in order to stop this forced truncating? Thanks in advance, Chaiyaphum.

Options: ReplyQuote


Subject
Views
Written By
Posted
Truncating comments using STRICT_TRANS_TABLES
3169
June 22, 2012 07:42AM


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.