MySQL Forums
Forum List  »  Newbie

Re: How to solve mysql data type convert exception
Posted by: karl ye
Date: July 20, 2015 10:29AM

Thank you very much for your professional suggestion.

In oracle or sqlserver, if the data types are not compatible, then the converse will stop and show error, but in mysql is different, it can converse and truncated, give you an unexpected result and only show warning. I think the first result is safer than the second result.

Options: ReplyQuote




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.