Database Options
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 setting on the page Options Tab for a detailed explanation of character sets.
For more information about creating databases, see the Language Reference Guide. 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.