Arabic Letters

--MYWAYBOUNDARY_000__ab3e70120a0ea4157960b04ba44378a1
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have a web site with 80,000+ members. Usernames are all in Arabic letters. When I use a regular "select * from users where username = 'abc'" where abc is the Arabic user name of someone, it gives me more than one username (although letters are different and usernames do not match). Is there anything to do with this?Thanks.

_______________________________________________
No banners. No pop-ups. No kidding.
Introducing My Way - http://www.myway.com

--MYWAYBOUNDARY_000__ab3e70120a0ea4157960b04ba44378a1--

Re: Arabic Letters

Lordo writes:
> I have a web site with 80,000+ members. Usernames are all in Arabic letters. When I use a regular "select * from users where username = 'abc'" where abc is the Arabic user name of someone, it gives me more than one username (although letters are different and usernames do not match). Is there anything to do with this?Thanks.
>

Hi!

This list is dedicated to the fully repeatable bug reports.

We truly do not see how we can repeat the above test case.

--

Sincerely,

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

Re: Arabic Letters

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lordo wrote:
> I have a web site with 80,000+ members. Usernames are all in Arabic letters.
> When I use a regular "select * from users where username = 'abc'" where abc
> is the Arabic user name of someone, it gives me more than one username
> (although letters are different and usernames do not match).

> Is there anything to do with this?Thanks.

Please provide repeatable test case if you believe this is a bug.

It must include MySQL release number, configuration (at least
- --default-character-set setting), some data and queries enough to reproduce your
problem.

CREATE TABLE x ..
INSERT ...

SELECT ...


Best way of reporting bugs is by filling bug report at http://bugs.mysql.com

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


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/3iWkeehWBZ4HcYkRAp1eAKDL4PQzvxv16iCg9Pv+bcOad2cf/QCe Mo3Q
4/augvoz3thRcpGLPfklWP8=
=Fdup
-----END PGP SIGNATURE-----


--
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: Arabic Letters

Hi,

> I have a web site with 80,000+ members. Usernames are all in Arabic lette=
rs.
> When I use a regular "select * from users where username =3D 'abc'" where a=
bc is
> the Arabic user name of someone, it gives me more than one username (alth=
ough
> letters are different and usernames do not match). Is there anything to d=
o
> with this?Thanks.

What MySQL version and what character set are you using?

The "where field=3D'something'" search is case insensitive, so you might run
into a situation, where the characters in the character set set in the
server are the same, but of different case.

If this is the case, the following statement should "fix" your problem,
although the correct solution would still be to set a correct character set
in the server:

SELECT * FROM USERS WHERE binary username =3D 'abc'


Rgds,
Indrek

--=20
| Indrek Siitan, Administrative Coordinator of Support
| MySQL (AB, GmbH, Inc.) =B7 Keila, Estonia
+-=20
| Want to swim with the dolphins? (April 14-16, 2004)
| http://www.mysql.com/uc2004/
--


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