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

[Matthew Bagley]

From what I understand what you want to do is this.

Search the database for the character 'A' and return all alternatives of that character á for example.

rather than converting the character into every type available and searching that way you would be better doing this

SELECT * FROM 8888n8866 WHERE codechar = 'A'

And your insert statements would be

INSERT INTO `8888n8866` (`codechar`, `CText`, `4row`, `Code`, `2row`, `8888old`, `8866`, `8888new`, `asciiValue`) VALUES
('A','Ａ', '''', 'HFFFD', '', '''', '~#A', '#A', 'EFBCA1'),
('A','ａ', '''', 'HFFFD', '', '''', '~#a', '#a', 'EFBD81'),
('A','ā', '''', 'HFFFD', '', '''', '~(!', '(!', 'C481'),
('A','á', '''', 'HFFFD', '', '''', '~(', '(''', 'C3A1'),
('A','ǎ', '''', 'HFFFD', '', '''', '~(#', '(#', 'C78E'),
('A','à', '''', 'HFFFD', '', '''', '~($', '($', 'C3A0');