MySQL Forums
Forum List  »  Install & Repo

sql_mode
Posted by: Frank Natoli
Date: February 25, 2006 06:19PM

With latest MySQL server, handling of invalid data has changed. my.ini by default sets sql_mode to STRICT_TRANS_TABLES, which apparently results in Java throwing SQLException when inserted data that exceeds the element width. Changed my.ini to not mention STRICT_TRANS_TABLES. Stopped and restarted service. Verified with SELECT @@global.sql_mode that the change had taken effect. Yet Java is still throwing SQLException. How to convince MySQL to behave as it formerly did, simply truncating data. Thanks.

Options: ReplyQuote


Subject
Written By
Posted
sql_mode
February 25, 2006 06:19PM


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.