c# 4.0 - accented chars in windows 8.1 embeded Sqlite -
i'm in struggle sqlite , accented chars such á or é.
what i'm trying select accent insensitive.
select * customers name "%risque%"
in database
-> id =1; name=risqué -> id =2; name=risque second
d
the select return record id =2 name=risque second
i've tried:
select * customers name "%risque%" collate nocase select * customers name "%risque%" collate noaccents
Comments
Post a Comment