Issue Bug Closed

#22933Install tool should by default create database with utf8 charset

Michiel Roos 06/18/10, 22:14 updated 10/02/18, 12:23

Description

The installer creates a database with Latin1 caharacter set as default.

mysql> show create database intro;
+—————+—————————————————————————————————+ | Database | Create Database |
+—————+—————————————————————————————————+ | intro | CREATE DATABASE `intro` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+—————+—————————————————————————————————+
1 row in set (0.01 sec)

This should look like:
mysql> show create database intro;
+—————+————————————————————————————————+ | Database | Create Database |
+—————+————————————————————————————————+ | intro | CREATE DATABASE `intro` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+—————+————————————————————————————————+
1 row in set (0.00 sec)

Which is the result of creating a database using: CREATE DATABASE intro CHARACTER SET utf8 COLLATE utf8_general_ci;

(issue imported from #M14787)

Reviews 1