vendredi 19 juin 2015

sqlite LIKE command with other alphabets

I am writing a program that makes queries to a database, but most of the entries are written in cyrillic alphabet ("П,п Б,б"). The problem is that LIKE is case insensitive but it doesn't work for cyrillic letters. For example when I write a query to find the word ("Апартамент") it will not work with ("апартамент") but it will work with ("партамент") because we are omitting the "A" (it is in cyrillic). I am using the following query command:

"SELECT * FROM Clients "
                        + "WHERE Name LIKE " + "'" + '%' + 
                        impname.getText()+ '%' + "'"

where impname is user given input.

Thank you in advance.

Aucun commentaire:

Enregistrer un commentaire