Bug #487 UTF-8 encoding request
Submitted: 23 May 2003 19:24 Modified: 11 Aug 2003 23:53
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Linux (Linux)
Assigned to: Alexander Barkov CPU Architecture:Any

[23 May 2003 19:24] [ name withheld ] 
Description:
Default encoding of Mysql(Binary)is iso-8859-1. It always leads to many problems when in Chinese/Japanese, especially when comparing fields wiht case insensitive.

Although we can set binary attribute on text fields, or just compile from source with different encoding, but why not make it better by mysql itself?

How to repeat:
select * from table where field like '%—›%'

won't work in fields without binary attribute specified.

Suggested fix:
If it is possible, Mysql 5 should use UTF-8 as its default encoding. So, characters of foreign languages would not be changed when performing case converting.
[8 Aug 2003 2:47] Lenz Grimmer 
Assigned to bar for consideration.
[11 Aug 2003 23:53] Alexander Barkov 
You should use proper mysqld startup options to run server
with the character set you want. You work with Ghinese gb2312 data,
just run mysqld:

  mysqld --default-character-set=gb2312