Ubuntu
mysql-dfsg-5.1 package

MySQL Server character set and collation not UTF-8 by default

Bug #521936 reported by Vladimir Osintsev on 2010-02-14

This bug report is a duplicate of: Bug #34181: locale and charset problem in mysql - default character set should be set to utf8. Edit Remove

This bug affects 2 people

Affects		Status	Importance	Assigned to	Milestone
	MySQL Server	New	Unknown	debbugs #476865
	mysql-dfsg-5.1 (Ubuntu)	Triaged	Wishlist	Unassigned

Bug Description

Would be logical to have utf8 as default character set with utf8_general_ci collation by default.

ProblemType: Bug
Architecture: i386
Date: Mon Feb 15 02:05:44 2010
DistroRelease: Ubuntu 9.10
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['mysql', 'debian-5.1.flag', 'ibdata1', 'ib_logfile0', 'ib_logfile1', 'mysql_upgrade_info', 'sweep_test', 'sweep']
Package: mysql-server-5.1 5.1.37-1ubuntu5.1
ProcEnviron:
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-19.56-generic-pae
SourcePackage: mysql-dfsg-5.1
Uname: Linux 2.6.31-19-generic-pae i686

Tags:

Revision history for this message

Vladimir Osintsev (osintsev) wrote on 2010-02-14:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (787 bytes, text/plain; charset="utf-8")
Dependencies.txt Edit (1.2 KiB, text/plain; charset="utf-8")
Logs.var.log.daemon.log.txt Edit (9.3 KiB, text/plain; charset="utf-8")
Logs.var.log.kern.log.txt Edit (29.8 KiB, text/plain; charset="utf-8")
MySQLConf.etc.mysql.my.cnf.txt Edit (4.1 KiB, text/plain; charset="utf-8")

summary:	- Default character set and collation not UTF-8 + Server character set and collation not UTF-8 by default
summary:	- Server character set and collation not UTF-8 by default + MySQL Server character set and collation not UTF-8 by default