Search Postgresql Archives

ilike, ~*, ~~* does not work on 8.0.3 (db encoding - UNICODE)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I can not get work ilike, ~*, ~~* with not ascii chars, but upper,lower, order by - work good.db encoding is UNICODE.
test=> SELECT 'Тест' ~~* 'тест'; ?column? ---------- f
test=> SELECT 'Тест'' ~* 'тест'; ?column? ---------- f
test=> SELECT 'Тест'' ILIKE 'тест'; ?column? ---------- f
test=> SELECT upper('Тест'') ~~ upper('тест'); ?column? ---------- t

tesscom=> SELECT upper('Тест'') ~ upper('тест'); ?column? ---------- t
---------------------------(end of broadcast)---------------------------TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux