Regading Varchar(10) behaviour in two different platform
i have two setup(X,Y) where i have a one column abc varchar(20); i n table Z i am inserting value 255:255:255 in abc column; but setup x select abc from Z; abc 255:255:25
and another setup Y shows select abc from Z;
| abc |
+---------+
why Varchar is showing different behavior??
Answer Answered by Daniel Black in this comment.
possibly SQL_MODE=STRICT_TRANS_TABLES or STRICT_ALL_TABLES
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
