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

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -