\encoding LATIN1
show client_encoding;
show server_encoding;
drop table t1;
create table t1(t text);
insert into t1 values('ト');
select * from t1;
-- this doesn't work
select lower('ト');
-- this doesn't work either
select lower(t) from t1;
-- this works
select convert(lower(convert(t, 'LATIN1')),'LATIN1','UNICODE') from t1;
-- ditto
select convert(lower(convert('ト', 'LATIN1')),'LATIN1','UNICODE');