column name work as a case insenstive

we are facing below issue where lower_case_table_names set it to 1. for Example ::we have a table 'x' which has 3 or n column, and column col1 is a char(1) type and that is our unique key as well. while inserting the data in table ' insert ..... value(chr(97),...,...) it got inserted successfully and when i insert another data ' insert ..... value(chr(65),...,...)

it gives an error "duplicate entry for 'A'" ERROR 1062 (23000): Duplicate entry 'A-0' for key

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.