Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help

[stephen selvaraj]

Thanks for your reply. You rephrase my question and tell that is the answer. My question is I just want to retrieve a single record for a search value. If my search value is ‘á’, I just want to get the respective record for that value only not all the 6 records.

For example:
mysql> SELECT HEX(CText), asciiValue, CText FROM `8888n8866` WHERE CText=" á ";

+------------+------------+-------+
| HEX(CText) | asciiValue | CText |
+------------+------------+-------+
| C3A1 | C3A1 | á |
+------------+------------+-------+

I know very well all the six rows match to the search value ‘A’. but my question is what I supposed to do in order to get a single record for my search value in the varchar datatype and collation is utf8_unicode_ci