multi byte chartacter issue in redshift

I am unable to convert multibyte characters in redshift.

create table temp2 (city varchar);

insert into temp2 values(‘г. красноярск’); // lower value

insert into temp2 values(‘Г. Красноярск’); //upper value

select * from temp2 where city ilike ‘Г. Красноярск’


Г. Красноярск

I tried like below, UTF-8 characters are converting into lower.

select lower(‘Г. Красноярск’)


г. красноярск

In vertica it is working fine with using lowerb() function, Please help me.


Source: New Questions

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.