Re: Arabic Letters

Hi,

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

What MySQL version and what character set are you using?

The "where field='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 = 'abc'


Rgds,
Indrek

-- 
|  Indrek Siitan, Administrative Coordinator of Support
|  MySQL (AB, GmbH, Inc.) · Keila, Estonia
+- 
|  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/[email protected]