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.
The question does not seem to be about column names but the data that is being inserted into the column. Can you post the output of
SHOW CREATE TABLE x;? Can you define the indexed column with a case-sensitive collation instead of a case-insensitive (ci) one?'a'='A'should hold in case-insensitive collations but not case-sensitive ones.collations is set DEFAULT for column 'col' ....Below is output of SHOW CREATE TABLE x;
Output :: SHOW CREATE TABLE x;
"col" char(1) DEFAULT NULL,
UNIQUE KEY "X_col" ("col","part"),
) default for latin1 characterset. latin1_swedish_ci