Live Chat Software by Kayako |
Knowledgebase
|
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)