[sqlite] unicode like UPPER and LOWER ?

[Kirill]

Good day,

SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table tbl1(t1 varchar(10));
sqlite> insert into tbl1 values('софт'); - lowChar
sqlite> insert into tbl1 values('СОФТ'); - upChar
sqlite> select * from tbl1;
софт
СОФТ
sqlite> select * from tbl1 where t1 like '%оф%';  - lowChar
софт - lowChar

:(

what do?:

sqlite> select * from tbl1 where t1 like '%оф%';  - lowChar
софт - lowChar
СОФТ - upChar


-- 
Best regards,
  Kirill
  mailto:[EMAIL PROTECTED]




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------