I decided to install MariaDB, but problems with the encoding. I make a simple Insert with Russian characters and get hieroglyphs. How can I change the encoding to utf-8?
- oneru.stackoverflow.com/a/433949/178576 - aleksandr barakin
|
1 answer
SET character_set_server = 'utf8'; SET collation_server = 'utf8_unicode_ci';
or my.cnf:
[client] ... default-character-set=utf8 ... [mysql] ... default-character-set=utf8 ... [mysqld] ... collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8 ...
- I wrote the first item, something doesn't work - Rakzin Roman
- Well, you need to create a new database, since the old one was not created by default in utf8. Changing the config will require server overload. - pavelip 5:53 pm
- Thank. Earned)) - Rakzin Roman
|