- 再現デモ
- 解決編
- まとめ
- 蛇足
--
docker run -d --name postgres_1 postgres:11.5
docker exec -it postgres_1 psql -U postgres
--
create table hoge ( id int, value varchar(10));
insert into hoge values
(1, 'あ'),
(2, 'あ（ほげ）'),
(3, 'い'),
(4, 'い（ふが）')
;
select * from hoge order by value;
--
postgres=# select * from hoge order by value;
id | value
----+------------
1 | あ
3 | い
2 | あ（ほげ）
4 | い（ふが）
(4 rows)
--
postgres=# SHOW LC_COLLATE;
lc_collate
------------
en_US.utf8
(1 row)
--
LC_COLLATE 文字列の並び換え順
https://www.postgresql.jp/document/12/html/locale.html
--
FROM postgres:11.5
RUN localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8
ENV TZ=Asia/Tokyo
ENV LANG=ja_JP.UTF-8
ENV LANGUAGE=ja_JP:ja
ENV LC_ALL=ja_JP.UTF-8
--
docker build . -t postgres_i
docker run -d --name postgres_2 postgres_i
docker exec -it postgres_2 psql -U postgres
--
create table hoge ( id int, value varchar(10));
insert into hoge values
(1, 'あ'),
(2, 'あ（ほげ）'),
(3, 'い'),
(4, 'い（ふが）')
;
select * from hoge order by value;
--
postgres=# select * from hoge order by value;
id | value
----+------------
1 | あ
2 | あ（ほげ）
3 | い
4 | い（ふが）
(4 行)
--
postgres=# SHOW LC_COLLATE;
lc_collate
-------------
ja_JP.UTF-8
(1 行)
--
- ちょっと使うだけでもしっかり設定しよう
- 日本という環境は不利
- 詳細は blog に書いた
--
--
docker run --name mysql_1 -e MYSQL_ROOT_PASSWORD=mysql -d mysql
docker exec -it mysql_1 mysql -u root -p -h 127.0.0.1 -D mysql -pmysql
--
mysql> create table hoge ( id int, value varchar(10));
Query OK, 0 rows affected (0.04 sec)
mysql> insert into hoge values
-> (1, ''),
-> (2, ''),
-> (3, ''),
-> (4, '')
-> ;
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0
※日本語が入力できない
--
mysql> select * from hoge;
+------+-------+
| id | value |
+------+-------+
| 1 | |
| 2 | |
| 3 | |
| 4 | |
+------+-------+
4 rows in set (0.00 sec)
--
mysql> status
--------------
mysql Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)
（略）
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: latin1
Conn. characterset: latin1
--
mysql> SHOW VARIABLES LIKE "char%";
+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.01 sec)
--
- 接続前
docker exec -it mysql_1 mysql -u root -p -h 127.0.0.1 -D mysql -pmysql --default-character-set=utf8mb4
- 接続後
SET character_set_client = utf8mb4;
SET character_set_results = utf8mb4;
--
mysql> status
--------------
（略）
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
--
mysql> SHOW VARIABLES LIKE "char%";
+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.00 sec)
--
- だめでした
- サーバ側の設定を変更する必要があり（知ってた）
- Docker の MySQL コンテナを日本語対応させる - Qiita
- 試してない