drop database if exists dump_semantic_char_db;
create database dump_semantic_char_db;
\c dump_semantic_char_db
create table test_charbyte_bpchar (id int, city char (4 char));
insert into test_charbyte_bpchar values(1, 'abcd');
insert into test_charbyte_bpchar values(2, '中国天津');
create table test_charbyte_varchar (id int, city char (4 char));
insert into test_charbyte_varchar values(1, 'abcd');
insert into test_charbyte_varchar values(2, '中国天津');
\! @abs_bindir@/gs_dump dump_semantic_char_db -p @portstring@ -f @abs_bindir@/dump_semantic_char_db.tar -F t >/dev/null 2>&1; echo $?
drop database if exists restore_semantic_char_db;
create database restore_semantic_char_db;
\! @abs_bindir@/gs_restore -d restore_semantic_char_db -p @portstring@ @abs_bindir@/dump_semantic_char_db.tar >/dev/null 2>&1; echo $?
\c restore_semantic_char_db
\d+ test_charbyte_bpchar
\d+ test_charbyte_varchar
select * from test_charbyte_bpchar;
select * from test_charbyte_varchar;
\c regression
drop database if exists restore_semantic_char_db;
drop database if exists dump_semantic_char_db;