Why search functionality (login, etc) is case sensitive at my website (MySQL case sensitivity / collations) ?
Posted by Esvon Support on 27 June 2007 04:20 PM

This problem is rare and happens due to MySQL collations settings.

Try to find out if your database/tables are set to utf8_bin or other collation (via phpMyAdmin or ask hosting provider). Any collation that ends in "_bin" or "_cs" is case sensitive. If you would like to use utf8 without it being case sensitive, try modifying your databases to use utf8_general_ci instead. All of the _ci collations are case insensitive.

If you login to your cPanel account and go to MySQL -> PHPMyAdmin, you can browse your databases and tables there, as well as change the collation for each database and table.

Comments (0)
Help Desk Software by Kayako Fusion