upper function for chinese issue

Dear Sir,

When I use mysql to maintain my chinese data, I found some bug for upper function:

mysql> select UPPER('麦');
+-------------+
| UPPER('麦') |
+-------------+
| 掠          |        <<error
+-------------+
1 row in set (0.00 sec)

mysql> select * from sys_synonym where  locate(upper('麦'),upper(word))>0;
+-------+----------+
| id    | word     |
+-------+----------+
|    10 | 光影合成 |       << error
|   358 | 麦       |
|   512 | 丹麦     |
|   878 | 光影     |       << error
|   358 | 麦子     |
|   358 | 小麦     |
|   750 | 下雨     |       << error
|   988 | 章鱼     |
| 14143 | 麦克风   |
| 14016 | 谷麦加工 |
| 12304 | 麦田     |
+-------+----------+
11 rows in set (0.02 sec)

mysql> select * from sys_synonym where word like '麦';
+-------+----------+
| id    | word     |
+-------+----------+
|    10 | 光影合成 |       << error
|   358 | 麦       |
|   512 | 丹麦     |
|   878 | 光影     |       << error
|   358 | 麦子     |
|   358 | 小麦     |
|   750 | 下雨     |       << error
|   988 | 章鱼     |
| 14143 | 麦克风   |
| 14016 | 谷麦加工 |
| 12304 | 麦田     |
+-------+----------+
11 rows in set (0.02 sec)

if you can not read the chinse chars on your machine , pls view the attached image.

thanks!

Br, 
Jimmy zhou

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]