hello:
plz replace with "word char(10) binary" in your db.
or use sql like this: "select * from sys_synonym where word like binary
'%=C2=F3%';
or recompile mysql by "--with--charset=3Dgbk";
-Darks
-----=D3=CA=BC=FE=D4=AD=BC=FE-----
=B7=A2=BC=FE=C8=CB: Jimmy [mailto:jimmy.zhou [at] ithospital.com]
=B7=A2=CB=CD=CA=B1=BCä: 2003=C4=EA8=D4=C25=C8=D5 11:00
=CA=D5=BC=FE=C8=CB: bugs [at] lists.mysql.com
=D6=F7=CC=E2: 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('=C2=F3');
+-------------+
| UPPER('=C2=F3') |
+-------------+
| =C2=D3 | <<error
+-------------+
1 row in set (0.00 sec)
mysql> select * from sys_synonym where
mysql> locate(upper('=C2=F3'),upper(word))>0;
+-------+----------+
| id | word |
+-------+----------+
| 10 | =B9=E2=D3=B0=BA=CF=B3=C9 | << error
| 358 | =C2=F3 |
| 512 | =B5=A4=C2=F3 |
| 878 | =B9=E2=D3=B0 | << error
| 358 | =C2=F3=D7=D3 |
| 358 | =D0=A1=C2=F3 |
| 750 | =CF=C2=D3=EA | << error
| 988 | =D5=C2=D3=E3 |
| 14143 | =C2=F3=BF=CB=B7=E7 |
| 14016 | =B9=C8=C2=F3=BC=D3=B9=A4 |
| 12304 | =C2=F3=CC=EF |
+-------+----------+
11 rows in set (0.02 sec)
mysql> select * from sys_synonym where word like '=C2=F3';
+-------+----------+
| id | word |
+-------+----------+
| 10 | =B9=E2=D3=B0=BA=CF=B3=C9 | << error
| 358 | =C2=F3 |
| 512 | =B5=A4=C2=F3 |
| 878 | =B9=E2=D3=B0 | << error
| 358 | =C2=F3=D7=D3 |
| 358 | =D0=A1=C2=F3 |
| 750 | =CF=C2=D3=EA | << error
| 988 | =D5=C2=D3=E3 |
| 14143 | =C2=F3=BF=CB=B7=E7 |
| 14016 | =B9=C8=C2=F3=BC=D3=B9=A4 |
| 12304 | =C2=F3=CC=EF |
+-------+----------+
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/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org
