´ð¸´: 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=3Dgbk";

-Darks


-----ÓʼþÔ­¼þ-----
·¢¼þÈË: Jimmy [mailto:jimmy.zhou@ithospital.com]=20
·¢ËÍʱ¼ä: 2003Äê8ÔÂ5ÈÕ 11:00
ÊÕ¼þÈË: bugs@lists.mysql.com
Ö÷Ìâ: 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('Âó') |
+-------------+
| ÂÓ | < +-------------+
1 row in set (0.00 sec)

mysql> select * from sys_synonym where =20
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,=20
Jimmy zhou



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org