How to insert cyrillic characters in a sqlite table using fts3 in android -

How to insert cyrillic characters in a sqlite table using fts3 in android -

i have sqlite database in android app tables virtual because need fast search on whole tables. i'm using , extended class of sqliteopenhelper open database.

here illustration of table create use:

create virtual table person using fts3(firstname varchar(50), lastname varchar(50))

everything works fine long every text insert in latin characters. unfortunatly whenever seek insert cyrillic characters sqliteexception near cyrillic character says syntax error.

example:

insert person (firstname, lastname) values ('john','Россия') android.database.sqlite.sqliteexception: near "Россия": syntax-error: insert person (firstname, lastname) values ('john','Россия')

as far know sqlite uses utf-8 standard. have tried without using fts3 (no virtual table), result same.

could help me find out i'm missing insert cyrillic text database?

android sqlite utf-8 cyrillic