본문 바로가기

Programming/DB

[firebirdsql] create database

for windows



installDir\bin\> isql -s 1 -ch KSC_5601

SQL> create database 'c:\testdb.fdb' user 'usr1' password '87654321' page_size 8192 default character set KSC_5601;

SQL> show db;

Database: c:\testdb.fdb

        Owner: usr1

PAGE_SIZE 8192

Number of DB pages allocated = 164

Sweep interval = 20000

Forced Writes are ON

Transaction - oldest = 1

Transaction - oldest active = 2

Transaction - oldest snapshot = 2

Transaction - Next = 5

ODS = 11.2

Default Character set: KSC_5601

SQL> _