MySQL Forums
Forum List  »  General

Query results problem
Posted by: Matt Glosson
Date: June 11, 2012 07:07AM

I have a table with Arabic text. There are two unique rows:

اِس
اُس

The first one consists of the following characters: 0x0627, 0x0650, 0x0633
The second one consists of the following characters: 0x0627, 0x064F, 0x0633

The problem is if I query for either of these, they both show up. This happens both on the command line and using phpmyadmin. Here is what I type for a query:

SET NAMES utf8;
SELECT urdu FROM transliteration WHERE urdu LIKE 'اِس';

Any thoughts? Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Query results problem
June 11, 2012 07:07AM
June 11, 2012 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.