2020年06月27日

Firebird 2.5.9

Windows ISQL


SQL> create database 'C:\data\sample.fdb'
CON> user 'sysdba'
CON> password 'masterkey'
CON> default character set utf8;
SQL> commit;

create database 'C:\data\s2.fdb' user 'sysdba' password 'masterkey' default character set cp932;

create database 'C:\data\s3.fdb' user 'sysdba' password 'masterkey' default character set sjis0208;

SQL> connect 'C:\data\sample.fdb'
CON> user 'sysdba'
CON> password 'masterkey';
Database: 'C:\data\test.fdb', User: sysdba

SQL> create table test (id int, name varchar(100));
SQL> insert into test(id,name) values (1, 'test_value');
SQL> commit;

SQL> select * from test;

quit;
posted by a23 at 14:42| Comment(0) | Firebird