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

[Rick James]

Sorry I continue to be puzzled.
The query you gave showed no rows, so I added two rows:
mysql> INSERT INTO `8888n8866` VALUES ('A','','','','','','', HEX('A'));
mysql> INSERT INTO `8888n8866` VALUES ('a','','','','','','', HEX('a'));
Then
SELECT HEX(CText), asciiValue, CText FROM `8888n8866`
WHERE CText="A" COLLATE utf8_bin;
delivered one row, the one with AsciiValue = '41';

Do you get all 6 (or now 8) rows?