Subject Re: [firebird-support] Create Database
Author Paul Vinkenoog
Hi Uwe,

> Please point out the obvious to me why PAGE_SIZE is not anymore
> recognised in the create database statement. Did I go over a limit
> or something. Oddly it does still create the database file and gfix
> reports no errors.

> C:\Firebird\bin>isql
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> CREATE DATABASE 'D:\Test2\Data.FDB'
> CON> user 'sysdba'
> CON> password 'masterkey' ;
> SQL> PAGE_SIZE = 8192
> CON> DEFAULT CHARACTER SET NONE ;
> Statement failed, SQLCODE = -104

The PAGE_SIZE and charset stuff should be part of the CREATE
statement, but you closed it with the ";" after 'masterkey'. That's
why the database is created OK but the following lines are considered
an (invalid) statement by themselves.

Drop the first ";" and it should work.


Greetings,
Paul Vinkenoog