Unanswered: ILIKE fails when operates on multy bite characters
I am using postgresql 8.2.14 on my system.
When I am executing a query like SELECT * FROM <table> WHERE term ILIKE <some_lowercase_term> it does not give any result though the database contains matching data. Note that the matching data contains double byte characters.
E.g. The query SELECT * FROM table1 WHERE term ILIKE 'ｆａｓｔ' does not return any entry although the table contains the entry "ＦＡＳＴ".
The locale settings of the database have been set to C when initdb runs. And we are unable to modify locale settings since it is mentioned that modifying locale settings (LC_COLLATE, LC_CTYPE).
- Are there any workaround to execute above query successfully without changing the locale?
- Are that possible to modify locale settings without damaging database and how?