1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Forcing the default charset to connect to the database
Our MySQL server settings force the use of UTF-8 by default.
If you need to define the storages in Latin characters, for example, you'll need to add the following lines in the PHP section of your query:
mysql_query("SETCHARACTER SET latin1");
On the old admin console, you could force the MySQL connection in latin1 via the .htaccess file in the root of your hosting:
php_value mysql.connect_charset latin1
php_value mysqli.connect_charset latin1
php_value pdo_mysql.connect_charset latin1
On the new admin console, you must place this code into a .user.ini file located in the root of your hosting :
mysql.connect_charset = "latin1"
mysqli.connect_charset = "latin1"
pdo_mysql.connect_charset = "latin1"