#! /bin/sh
# -*- coding: utf-8-unix; -*-

. 0common.sh

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

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

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

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

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