Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.1.7
-
CentOS 7.1
Description
( First of all, sorry for my poor english. My mother tongue is not english. )
1. Add below statement to /etc/my.cnf.d/server.cnf
character-set-server = utf8
collation-server = utf8_general_ci
2. Restart DB and check character set.
3. Create new database and move to that database.
(e.g. CREATE DATABASE testDB; )
(e.g. USE testDB; )
4. Create table without 'CHARACTER SET' option.
(e.g. CREATE TABLE testTable; )
5. Check 'SHOW CREATE TABLE' statement result.
( e.g. SHOW CREATE TABLE testTable; )
You can see 'character_set_database' value is still latin1
In MariaDB 10.0.21, Once I set 'character-set-server = utf8', all tables are created with utf8 even though I didn't write the 'character_set' option in 'CREATE TABLE' statement. And I think this is normal.
Please check.
Thank you.