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?

1 answer 1

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