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]

I Need to retrive a value from a mysql database which its Collation as "utf8_unicode_ci" and Data Type as "Varchar".

In the Database i need to store a value such as eg(Ａ,ā, á, ǎ, à) and so on.

My Search string is 'A' so i expect the return result 'A' and its respective value "#A" for the column '8888new'.

But it return all values as below. pls help. how to search a unicode character?.

FOLLOWING TWO FIELDS DATA TYPE
CText varchar(50) utf8_unicode_ci
8888new varchar(50) utf8_unicode_ci

SQL SELECT QUERY
[ code ]SELECT DISTINCT `CText`,`8888new` FROM 8888n8866 WHERE `CText`= "A".[ /code ]

RESULT RETURN
CText, 8888new
Ａ, #A
a, #a
ā, (!
á, ('
ǎ, (#
à, ($

E.g. If i search for a value " à " i expect the respect result in the column 8888new = " ($ ".
[ code ]
CREATE TABLE IF NOT EXISTS `8888n8866` (
`CText` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`4row` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`Code` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`2row` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`8888old` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`8866` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`8888new` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
`asciiValue` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[ /code ]

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



Edited 3 time(s). Last edit at 07/06/2010 03:28AM by stephen selvaraj.