upper function for chinese issue

--=====000_Dragon103602458300_=====
Content-Type: text/plain;
charset="GB2312"
Content-Transfer-Encoding: quoted-printable

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 =
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


--=====000_Dragon103602458300_=====
Content-Type: text/plain; charset=us-ascii

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

Re: upper function for chinese issue

Hello,

Jimmy wrote:
> 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)

Which MySQL release do you use and what character set you have configured for both
server and client?

In order to accept bug report we need repeatable test case.

Best regards

--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




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

Re: 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 =
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


What charset are you using ???

What version of MySQL are you using ??

Can you try 4.1 which has better support for Chinese ??

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


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