答复: upper function for chinese issue

hello:

plz replace with "word char(10) binary" in your db.
or use sql like this: "select * from sys_synonym where word like binary
'%麦%';
or recompile mysql by "--with--charset=gbk";

-Darks


-----邮件原件-----
发件人: Jimmy [mailto:[email protected]] 
发送时间: 2003年8月5日 11:00
收件人: [email protected]
主题: 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  
mysql> 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]