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.
You haven't given any details of your table or the failing query, but it sounds like you're using a case-insensitive collation. See Character Set and Collation Overview.
For example:
Everything is fine if you use a case-sensitive collation:
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?