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' ;

The ";" is terminating the current statement.

> SQL> PAGE_SIZE = 8192
> CON> DEFAULT CHARACTER SET NONE ;
> Statement failed, SQLCODE = -104
>
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, char 1
> -PAGE_SIZE
> SQL>
> SQL> -- Select the database
> SQL>
> CON> CONNECT 'D:\Test2\Data.FDB'
> CON> user 'sysdba'
> CON> password 'masterkey' ;
> Commit current transaction (y/n)?y
> Committing.
> Database: 'D:\Test2\Data.FDB', User: sysdba

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com