Database Options

Go Up to Creating Databases

The database options that you can set are Page Size, Default Character Set, and SQL dialect.

Page Size (Database Options)

InterBase supports database page sizes of 1024, 2048, 4096, 8192, and 16384 bytes. The default is 4096 bytes.

Default Character Set

See Character Set in Table 9.2 for a detailed explanation of character sets.

For more information about creating databases, see the Language Reference. See the Data Definition Guide for an explanation of character sets.

SQL Dialect

An InterBase database SQL dialect determines how double quotes, large exact numerics, and certain data types such as SQL DATE, TIME, and TIMESTAMP are interpreted. In most cases you should create databases in dialect 3 in order to have access to all current InterBase features.

Changing a database dialect from 1 to 3 may require some preparation if it contains DATE data types, DECIMAL or NUMERIC data types with precision greater than 9, or has strings that are in double quotes rather than single quotes. For more information about dialects, refer to Understanding SQL Dialects in the migration appendix of the Operations Guide.

To Change the Database Dialect:

1. Highlight the database in the Tree pane and perform one of the following actions:

• Choose Database|Properties.
• Right-click and choose Properties from the context menu.
• Double-click Properties in the Work pane.

2. Click the General tab and change the SQL dialect in the Options field.

Tip: To suppress the display of system tables in IBConsole, deselect System Data from the View menu.