SQL UPPER not working

Question

I have a table

And try to execute this command :

SELECT * FROM projects WHERE (UPPER(title) LIKE '%КУ%' OR UPPER(description) LIKE '%КУ%')

In the end i want to get a row with id 2 but nothing returns to me.

But, when i change request to :

SELECT * FROM projects WHERE (UPPER(title) LIKE '%Ку%' OR UPPER(description) LIKE '%Ку%')

It returns row (as expected) with id 2.

What i doing wrong? Why UPPER not worked?

You might find this post interesting: http://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing — Phantômaxx, Sep 23 '15 at 09:53
Please check the version whether it supports in your's or not — koushik veldanda, Sep 23 '15 at 09:56

score 4 · Accepted Answer · edited Apr 13 '17 at 12:53

4

The problem is in Russian language :) UPPER is working only for latin alphabet. There is question about it in ru.stackoverflow

edited Apr 13 '17 at 12:53

Community

answered Sep 23 '15 at 09:58

Sergey Glotov

1 Answers1