Query results problem
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.
Subject
Written By
Posted
Query results problem
June 11, 2012 07:07AM
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.