Просмотр кода страницы Changing the default character set

[[Категория:DB]]

== Changing the default character set to UTF-8 ==

''vim /etc/my.cnf''

<syntaxhighlight lang="bash">
[client]
...
default-character-set=utf8mb4
...
[mysql]
...
default-character-set=utf8mb4
...
[mysqld]
...
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
</syntaxhighlight>
<syntaxhighlight lang="sql">
SET character_set_server = 'utf8mb4';
SET collation_server = 'utf8mb4_unicode_ci';
</syntaxhighlight>

== Create database whith utf8 character ==

<syntaxhighlight lang="sql">
CREATE DATABASE czech_slovak_names 
  CHARACTER SET = 'utf8mb4'
  COLLATE = 'utf8mb4_unicode_ci';
</syntaxhighlight>

== Alter database to utf8 character ==
<syntaxhighlight lang="sql">
ALTER DATABASE czech_slovak_names CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_unicode_ci';
</syntaxhighlight>