geez a language which this time give service mostly in churches of ethiopia.
geez has unique alphabets from any language in the world.
create table mytable( english varchar(40), geez Nvarchar(40))
insert into mytable values('caw',N'lam'); works fine.
insert into mytable values('ox',N'bere'); works fine.
Note that, in this code i simply put the value of geez column in latin alphabets, but assume that they are written in geez language.
then:
select * from mytable; this works fine
select * from mytable where english='ox'; works correct
but when i use geez in where condition ,it doesnot work correctly.
i try as follow
select * from mytable where geez=N'lam'; this doesnot work correctly.
select * from mytable where geez='lam'; this also doesnot work correctly.
so how can i select non english langauge from table?
thanks alot!