------------------------------------------------------------------------------------------------
CREATE DATABASE 'TS_SJIS.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE = 8192
DEFAULT CHARACTER SET SJIS_0208
------------------------------------------------------------------------------------------------
CREATE DATABASE 'TS_UTF8.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE = 8192
DEFAULT CHARACTER SET UTF8
------------------------------------------------------------------------------------------------
CREATE DATABASE 'TS_UNICODE.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE = 8192
DEFAULT CHARACTER SET UNICODE_FSS
------------------------------------------------------------------------------------------------
SJIS_0208
isql -u SYSDBA -p masterkey
Connect TS_SJIS.FDB;
Show Database;
Select xxx,yyy From xxxTable
表示OK
------------------------------------------------------------------------------------------------
UTF8
isql -u SYSDBA -p masterkey
Connect TS_UTF8.FDB;
Show Database;
Select xxx,yyy From xxxTable
MSゴジックにフォントを変更
chcp 65001
表示文字化け
------------------------------------------------------------------------------------------------
UNICODE_FSS
isql -u SYSDBA -p masterkey
Connect TS_UNICODE.FDB;
Show Database;
Select xxx,yyy From xxxTable
MSゴジックにフォントを変更後、chcp 65001
表示文字化け
------------------------------------------------------------------------------------------------
ISQL UTF8 / UNICODE_FSS日本語はダメだったかな?
アプリからの表示は、OK。
http://a23.sblo.jp/archives/20131118-1.html
