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 ‘Г. Красноярск’

city

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

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

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

lower

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

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

Thanks


Source: New Questions

Leave a Reply