- View the diff.
- View the source.
- Go to MySQL/utf8.
5: 2014-05-30 (Fri) 11:55:05 iseki | Cur: 2019-08-23 (Fri) 23:27:53 iseki | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | *** utf8mb4 [#i644bfc1] | ||
+ | - さらに utf8mb4 というのもある. | ||
+ | #br | ||
*** 作成時に文字コードを指定 [#v3d64d11] | *** 作成時に文字コードを指定 [#v3d64d11] | ||
mysql> CREATE DATABASE db_name DEFAULT CHARACTER SET utf8; | mysql> CREATE DATABASE db_name DEFAULT CHARACTER SET utf8; | ||
Line 9: | Line 12: | ||
[mysqld] | [mysqld] | ||
default-character-set=utf8 | default-character-set=utf8 | ||
- | -- 5.5.4-m3 では使用できないようだ | + | skip-character-set-client-handshake |
+ | [mysqld_safe] | ||
+ | default-character-set=utf8 | ||
+ | skip-character-set-client-handshake | ||
+ | - check | ||
+ | mysql> show variables like "char%"; | ||
#br | #br | ||
Line 56: | Line 64: | ||
- mb_internal_encoding("utf-8") は php.ini でも指定可能. | - mb_internal_encoding("utf-8") は php.ini でも指定可能. | ||
- SET NAMES utf8 でクエリの文字コードを指定可能. | - SET NAMES utf8 でクエリの文字コードを指定可能. | ||
+ | #br |
- Backup list of MySQL/utf8
- Backup diff of MySQL/utf8 vs current(No. All)