'MariaDB (v10.4.24)

I apologize in advance for my English.

I am sending an SQL query: SELECT * FROM `table` WHERE `cmd` = 'test' ; finds everything fine, but it's worth changing any letter with a different case (for example, `cmd' = 'Test') and the query does not return a row from the table.

Previously I used utf8_unicode_ci encoding and everything worked fine, but as soon as I set utf8mb4_unicode_ci encoding, everything stopped working

sqlencodingutf-8utf8mb4mariadb-10.4


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions