Comments - column name work as a case insenstive
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.
I guess they are facing the issue while inserting the value 'a' after inserting 'A'. As MariaDB is not able to identify whether the 'a' or 'A' are different. I think there might be some configuration that needs to be set so that the MariaDB works in Case-Sensitive mode.
Have you looked at the collation?
Yup, so if we change the default collation from "latin1_swedish_ci " to "latin1_bin" then the comparison will be case-sensitive. Thanks to you Let me modify this.
how can be set as a globally?.it will work for one table.
I think you'd have to change collation on all tables. And you can set collation for the database itself too, which affects newly created tables?