CREATE TABLE SYS.SYSINFO ( page_size INTEGER NOT NULL, encryption CHAR(1) NOT NULL, blank_padding CHAR(1) NOT NULL, case_sensitivity CHAR(1) NOT NULL, default_collation CHAR(10) NOT NULL, database_version SMALLINT NOT NULL classes_version CHAR(10) )
This table indicates the database characteristics as defined when the database was created using CREATE DATABASE. It always contains only one row.
page_size The Catalog page size specified to CREATE DATABASE. The default value is 1024.
encryption The value “Y” or “N” depending on whether encryption was specified with CREATE DATABASE.
blank_padding The value “Y” or “N” depending on whether the database was created to use blank padding for string comparisons in the database.
case_sensitivity The value “Y” or “N” depending on whether case sensitivity was specified with CREATE DATABASE. Case sensitivity affects value comparisons, but not table and column name comparisons. For example, if case sensitivity is enabled, the system catalog names such as SYSCATALOG must be specified in uppercase since that is how the name was spelled when it was created.
default_collation A string corresponding to the collation_label in SYSCOLLATE corresponding to the collation sequence specified with CREATE DATABASE. The collation sequence is used for all string comparisons, including searches for character strings as well as column and table name comparison.
database_version A small integer value indicating the database format. As newer versions of Sybase IQ become available, new features may require that the format of the database file change. The version number allows Sybase IQ software to determine if this database was created with a newer version of the software and thus cannot be understood by the software in use.
classes_version A small string describing the current version of the SYS.JAVA.CLASSES library that is currently installed on your computer.
