#! /bin/sh
# -*- coding: euc-jp-unix; -*-

. 0common.sh

cat <<EOSQL | ${mysqlcmd} --default-character-set=ujis
use test;
select '* create table' as '';
drop table if exists x_ujis;
create table x_ujis (
  c1 varchar(8)
 ,index idx_c1 (c1)
) default character set 'ujis';

select '* show default character set' as '';
show create table x_ujis;
select '';
show create database test;
select '';
show variables like 'character\_set%';

select '* insert and select' as '';
insert into x_ujis values
  ('あ')
 ,('い')
 ,('あ')
;

select '- with index' as '';
select * from x_ujis where c1 like 'あ%';

drop index idx_c1 on x_ujis;
select '- without index' as '';
select * from x_ujis where c1 like 'あ%';
EOSQL