migrationで作成したカラム
mysql> describe sales_master;
+————–+————–+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————–+————–+——+—–+———+—————-+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
| office | varchar(255) | YES | | NULL | |
| zipcode | varchar(8) | NO | | NULL | |
| prefecture | varchar(20) | NO | | NULL | |
| address | varchar(255) | NO | | NULL | |
| tel | varchar(15) | NO | | NULL | |
| fax | varchar(15) | YES | | NULL | |
| mail | varchar(255) | NO | | NULL | |
| name_top | varchar(255) | NO | | NULL | |
| position_top | varchar(100) | YES | | NULL | |
| created_at | datetime(6) | NO | | NULL | |
| updated_at | datetime(6) | NO | | NULL | |
+————–+————–+——+—–+———+—————-+
13 rows in set (0.00 sec)
これに手動でデータを挿入します。
mysql> insert into sales_master (name, office, zipcode, prefecture, address, tel, fax, mail, name_top, position_top) values (‘東京テクノロジー株式会社’, ‘本社’, ‘100-6321’, ‘東京都’, ‘千代田区丸の内2-4-1′, ’03-1234-5678′, ’03-1234-5679’, ‘info@tokyotech.com’, ‘山田太郎’, ‘代表取締役’);
ERROR 1366 (HY000): Incorrect string value: ‘\xE6\x9D\xB1\xE4\xBA\xAC…’ for column ‘name’ at row 1
mysql> show variables like “chara%”;
+————————–+—————————-+
| Variable_name | Value |
+————————–+—————————-+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+————————–+—————————-+
8 rows in set (0.01 sec)
$ sudo vi /etc/mysql/my.cnf
[mysqld] character-set-server=utf8 skip-character-set-client-handshake default-storage-engine=INNODB [mysqldump] default-character-set=utf8 [mysql] # default-character-set=utf8
$ sudo /etc/init.d/mysql restart
mysql> status;
————–
mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapper
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ”
Using delimiter: ;
Server version: 5.7.31-0ubuntu0.18.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 24 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 105 Flush tables: 1 Open tables: 98 Queries per second avg: 0.208
————–
$ sudo apt-get install language-pack-ja
$ sudo update-locale LANG=ja_JP.UTF-8
だめだ、万事休す
adminから入力できるようにする
/sales/admin.py
from django.contrib import admin from .models import Master admin.site.register(Master)
mysql> insert into sales_master (name, office, zipcode, prefecture, address, tel, fax, mail, name_top, position_top, created_at, updated_at) values (”, ”, ‘100-6321’, ”, ‘2-4-1′, ’03-1234-5678′, ’03-1234-5679’, ‘info@tokyotech.com’, ”, ”, ‘2020-08-22 15:00:00’, ‘2020-08-22 15:00:00’);
Query OK, 1 row affected (0.00 sec)
mysql> select * from sales_master;
+—-+——+——–+———-+————+———+————–+————–+——————–+———-+————–+—————————-+—————————-+
| id | name | office | zipcode | prefecture | address | tel | fax | mail | name_top | position_top | created_at | updated_at |
+—-+——+——–+———-+————+———+————–+————–+——————–+———-+————–+—————————-+—————————-+
| 3 | | | 100-6321 | | 2-4-1 | 03-1234-5678 | 03-1234-5679 | info@tokyotech.com | | | 2020-08-22 15:00:00.000000 | 2020-08-22 15:00:00.000000 |
+—-+——+——–+———-+————+———+————–+————–+——————–+———-+————–+—————————-+—————————-+
1 row in set (0.00 sec)
何故だ。。。取り敢えず頭を冷やそう。
