The Ultimate Guide to High Availability with MariaDB

Comments - Adding a latin name to a larin1 column works on 10.4, doesn't work on 10.5

2 years, 10 months ago Alexander Barkov
Re: Adding a latin name to a larin1 column works on 10.4, doesn't work on 10.5
This comment has the status of 'removed' and can only be seen by you.

Latin Small Letter L with Stroke does not exists in latin1.

MariaDB can do two things when an impossible character gets written to a column: - Issue a warning (the character gets replaced to the question mark in this case) - Issue an error

The choice between the warning and the error is made according to: - STRICT_TRANS_TABLES flag in sql_mode - STRICT_ALL_TABLES flag in sql_mode - The engine used.

It seems that after switch from 10.4 to 10.5 either of them have changed.

Please check the output of this script in both installations:

SELECT @@sql_mode;
SHOW CREATE TABLE <tablename>;
 
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.