SET client_encoding TO sjis; --drop table tb1; create table tb1 (col1 varchar (20)); --truncate table tb1; insert into tb1 values ('あいうえお'),('AIUEO'),('アイウエオ'); SELECT * FROM tb1; --切り替え用 SHOW client_encoding; SET client_encoding TO sjis; SET client_encoding TO utf8;