https://wiki.webko.net.ua/index.php?action=history&feed=atom&title=Changing_the_default_character_set
Changing the default character set - История изменений
2026-05-19T08:35:54Z
История изменений этой страницы в вики
MediaWiki 1.35.1
https://wiki.webko.net.ua/index.php?title=Changing_the_default_character_set&diff=568&oldid=prev
Sol: Новая страница: «Категория:DB == Changing the default character set to UTF-8 == ''vim /etc/my.cnf'' <syntaxhighlight lang="bash"> [client] ... default-character-se…»
2018-02-28T08:33:29Z
<p>Новая страница: «<a href="/index.php?title=%D0%9A%D0%B0%D1%82%D0%B5%D0%B3%D0%BE%D1%80%D0%B8%D1%8F:DB" title="Категория:DB">Категория:DB</a> == Changing the default character set to UTF-8 == ''vim /etc/my.cnf'' <syntaxhighlight lang="bash"> [client] ... default-character-se…»</p>
<p><b>Новая страница</b></p><div>[[Категория:DB]]<br />
<br />
== Changing the default character set to UTF-8 ==<br />
<br />
''vim /etc/my.cnf''<br />
<br />
<syntaxhighlight lang="bash"><br />
[client]<br />
...<br />
default-character-set=utf8mb4<br />
...<br />
[mysql]<br />
...<br />
default-character-set=utf8mb4<br />
...<br />
[mysqld]<br />
...<br />
collation-server = utf8mb4_unicode_ci<br />
init-connect='SET NAMES utf8mb4'<br />
character-set-server = utf8mb4<br />
</syntaxhighlight><br />
<syntaxhighlight lang="sql"><br />
SET character_set_server = 'utf8mb4';<br />
SET collation_server = 'utf8mb4_unicode_ci';<br />
</syntaxhighlight><br />
<br />
== Create database whith utf8 character ==<br />
<br />
<syntaxhighlight lang="sql"><br />
CREATE DATABASE czech_slovak_names <br />
CHARACTER SET = 'utf8mb4'<br />
COLLATE = 'utf8mb4_unicode_ci';<br />
</syntaxhighlight><br />
<br />
== Alter database to utf8 character ==<br />
<syntaxhighlight lang="sql"><br />
ALTER DATABASE czech_slovak_names CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_unicode_ci';<br />
</syntaxhighlight></div>
Sol