How do i Setup utf-8 as standard character set for a mysql server?

Question

do i have to recompile it?

i figured out diffent ways of setting the character set values see

http://dev.mysql.com/doc/refman/5.5/en/charset.html

but starting it with other values or my.cnf settings changed nothing. Because if i do:

sudo mysqld --verbose --help | grep charact

it always answers me latin1 as standard charset. the system is ubuntu lts server with a standard mysql install.

which values did you try to change? – ulidtko Jan 19 '11 at 13:48 — ulidtko, Jan 19 '11 at 13:48

score 6 · Accepted Answer · edited Jun 20 '20 at 09:12

6

Solution:

add this into my.cnf:

[mysqld]
character-set-server=utf8
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8

[mysql]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8

[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8

[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8

[mysqldump]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8

[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8

[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8
#end

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 19 '11 at 15:37

dgAlien

428
1
4
9

if you just want to configure the server. just create a config file like so: _/etc/mysql/conf.d/utf8.cnf_ [mysqld] character-set-server=utf8 default-character-set=utf8 – dgAlien Jul 21 '11 at 10:03
2

`default-character-set=utf8` It causes the server to not start, as the error what is saying on the logs. – SIFE Mar 11 '13 at 22:26
4

It looks like default-character-set is no longer allowed in the [mysqld] section – marsbard Mar 24 '13 at 10:32

Quique · Answer 2 · 2017-09-20T12:25:17.353

5

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-character-set-client-handshake

[client]
default-character-set   = utf8

[mysql]
default-character-set   = utf8

UPDATE: Nowadays you should probably use utf8mb4.

edited Sep 20 '17 at 12:25

answered May 14 '13 at 06:50

Quique

909
10
8

score 1 · Answer 3 · answered May 11 '15 at 20:03

Create file /etc/mysql/conf.d/mysqld.cnf with contents:

[mysqld]
character-set-server = utf8
collation-server = utf8_unicode_ci

If you omit collation-server it should be set up to utf8_general_ci.

I've tested this configuration with MySQL 5.6 on Ubuntu 15.04.

How do i Setup utf-8 as standard character set for a mysql server?

3 Answers3

Solution: