accented chars in windows 8.1 embeded Sqlite

Asked Dec 02 '14 at 00:13

Active Dec 02 '14 at 00:13

Viewed 74 times

I'm in a struggle with Sqlite and accented chars such as á or é.

What i'm trying to do is a select with where accent insensitive.

select * from customers where name like "%risque%"

in database

-> id =1; name=risqué 
-> id =2; name=risque second

the select return only record id =2 name=risque second

i've tried:

select * from customers where name like "%risque%" COLLATE NOCASE
select * from customers where name like "%risque%" COLLATE NOACCENTS

asked Dec 02 '14 at 00:13

Carlos Sousa

Think you have to build your own, http://www.sqlite.org/datatype3.html#collation NO ACCENTS isn't listed. – Chubosaurus Software Dec 02 '14 at 01:13
possible duplicate of [How to ignore accent in SQLite query (Android)](http://stackoverflow.com/questions/16282083/how-to-ignore-accent-in-sqlite-query-android) – CL. Dec 02 '14 at 08:33
already read the article, tried everything and can not :( – Carlos Sousa Dec 02 '14 at 16:35
COLLATE NOACCENTS [link](http://stackoverflow.com/questions/14009261/sqlite-accent-insensitive-search?rq=1) – Carlos Sousa Dec 02 '14 at 16:51

0 Answers0