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 sir, I understand you are trying to help. But again as what i said all are Unicode and 7000+ records. Your query can work for Unicode character "á". But its not work for "A".

SELECT HEX(CText), asciiValue, CText FROM `8888n8866` WHERE CText="á" COLLATE utf8_bin

SELECT HEX(CText), asciiValue, CText FROM `8888n8866` WHERE CText="A" COLLATE utf8_bin