djangoのローカル開発環境を作るためのsqlのDB登録方法
ただ、utf-8で行うだけ。create tableを本番と合わしたいなら確認すればいい。
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.02 sec)
mysql> use [database name];
mysql> show create table [table name] \G;
*************************** 1. row ***************************
Table: [table name]
Create Table: CREATE TABLE [table name] (
`id` int(11) NOT NULL AUTO_INCREMENT,
`at_date` datetime(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=latin1 <--- ここがlatan1だとうまく行かないことがある。
1 row in set (0.01 sec)
mysql> create database [database name] default character set utf8; <--- こうすれば日本語のunicodeに対処できる。
mysql> show create table [table name] \G;
*************************** 1. row ***************************
Table: [table name]
Create Table: CREATE TABLE [table name] (
`id` int(11) NOT NULL AUTO_INCREMENT,
`at_date` datetime(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 <--- OK
1 row in set (0.01 sec)
