Dear friends
I have an SQL server 2000 database table that stores Unicode data (Amharic language data)
This table has a column for storing sex.
When I insert data it inserts properly.
When I retrieve all data from the table it also works fine and displays the correct result.
But when I try to retrieve with some case for example when I ask
Select * from table myTable where sex=N'amharicFe male'
It displays all female and male.
So please tell me how I can search for Unicode (Amharic) texts.
I have an SQL server 2000 database table that stores Unicode data (Amharic language data)
This table has a column for storing sex.
When I insert data it inserts properly.
When I retrieve all data from the table it also works fine and displays the correct result.
But when I try to retrieve with some case for example when I ask
Select * from table myTable where sex=N'amharicFe male'
It displays all female and male.
So please tell me how I can search for Unicode (Amharic) texts.