Skip navigation links

MySQL Forums :: General :: Query results problem


Advanced Search

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 Matt Glosson 06/11/2012 07:07AM
Re: Query results problem Peter Brawley 06/11/2012 09:13AM
Re: Query results problem Matt Glosson 06/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.