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