MySQL Forge - A community development platform

mysql should use utf8 by default

Reported by ®om on 2008-09-11
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Forge
Undecided
Unassigned

Bug Description

The whole system (Ubuntu 8.04.1) uses utf8.
The default configuration of utf8 is iso8859-1, so the first thing to do after the installation of mysql-server is to change the encoding, by adding those lines :

character-set-server=utf8
skip-character-set-client-handshake

in the section [mysqld] of file /etc/mysql/my.cn

I think utf8 should be the default.

CombatWombat (combatwombat) wrote :

Seconded! LOUDLY!

I have gone through a lot of pain to realise this. My post here: http://combatwombat.7doves.com/2008/10/26/mysql-latin1-to-utf8-issues tells of how to fix the issue in detail.

It's a Mysql transport issue.

Web browser(utf8)<---->PHP app (utf8) <----->Mysql(Latin1 (8859-1))<----->Database(utf8)

results in bad encoding for characters on screen.

Ubuntu needs to change the default to UTF8, then let everyone know of this change. My Web host- bluehost.com - uses Ubuntu servers, as do I locally, and this is how have verified it.

me (qldaus09) on 2009-12-07
Changed in mysql-forge:
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers