postgresql - multi byte character issue in Redshift -

i unable convert multibyte characters in redshift.

create table temp2 (city varchar);  insert temp2 values('г. красноярск');  // lower value  insert temp2 values('Г. Красноярск'); //upper value  select * temp2 city ilike 'Г. Красноярск'  city           -------------  Г. Красноярск  

i tried below, utf-8 characters converting lower.

select lower('Г. Красноярск')  lower          -------------  г. красноярск  

in vertica working fine using lowerb() function.

internally like , ilike operators use postgresql's regular expression support.

support proper handling of utf-8 multibyte chars in regular expressions added in postgresql 9.2. redshift based on postgresql 8.2 (?) , looks haven't backported support forked version.

see postgresql regex match uppercase, unicode-aware

you can work around this, limitations, using like lower('Г. Красноярск') instead. expression index may useful.