mysql – problem with comparing strings constants containing national characters
I have the following test schema at MySQL 8.0.32: CREATE SCHEMA `test_schema` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_pl_0900_ai_ci ; CREATE TABLE `test_schema`.`test_table` ( `test_column` VARCHAR(64) NULL); INSERT INTO `test_schema`.`test_table` (`test_column`) VALUES(‘Łucja’); INSERT INTO `test_schema`.`test_table` (`test_column`) VALUES(‘Lucjan’); As one might expect, there is no explicit collation provided for the table and column, so they inherit the… Read More mysql – problem with comparing strings constants containing national characters