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

Prolog - Listing -

orchardcms - change base url in local copy in Orchard CMS -

linear regression - Trying to get confidence/prediction intervals with `predict.lm` in R, but I keep getting an error regarding my dichotomous variable -