Encryption type   Shows the encryption algorithm used in connection with the Encryption scope setting. If Encryption scope is either Database or Table (that is, either the database is encrypted or table encryption is enabled, respectively), the encryption type is either Simple, AES, AES256, AES_FIPS, or AES256_FIPS. If Encryption scope is None, Encryption type is None.

Encryption scope   Shows whether the database is encrypted, or whether table encryption is enabled for the database. The possible values are Table, Database, or None. If the setting is Table, table encryption is enabled and the database is not encrypted. If the setting is Database then the database is encrypted and table encryption is not enabled. If the setting is None, the database is not encrypted and table encryption is not enabled.

Case sensitive   This property applies to version 10 and earlier databases. Shows the status of the case sensitivity feature. Returns On if the database is case sensitive. Otherwise, it returns Off. In case sensitive databases, data comparisons are case sensitive. This setting does not affect the case sensitivity of identifiers. Passwords are always case sensitive.

Ignore trailing blanks   Shows whether the database ignores trailing blanks in comparisons. For example, if this option is set to No, then 'Dirk' is not the same as 'Dirk '.

Collation sequence   This property applies to version 10 and earlier databases. Shows the collation algorithm for the database. SQL Anywhere supports two collation algorithms: the SQL Anywhere Collation Algorithm (SACA), and the Unicode Collation Algorithm (UCA). SACA provides fast, compact, and reasonable sorting at the expense of linguistic correctness. UCA provides linguistic correctness, but with a small expense in storage requirements and execution time.

Character set encoding   The character set that is used for the database. This property applies to pre-version 10 databases.

CHAR collation sequence   The collation that is used for CHAR data. See Collations in a SQL Anywhere database.

CHAR character set encoding   The character set that is used for CHAR data.

CHAR case sensitivity   Shows the case sensitivity setting for the CHAR collation. Possible values are: Ignore, Respect, UpperFirst, and LowerFirst. This property applies to version 10 and later databases. For information about these values, see Collation tailoring options.

NCHAR collation sequence   The collation used for NCHAR data. This value is either UCA or UTF8BIN.

NCHAR character set encoding   The character set that is used for NCHAR data. This is always UTF-8.

NCHAR case sensitivity   Shows the case sensitivity setting for the NCHAR collation. Possible values are: Ignore, Respect, UpperFirst, and LowerFirst. This property applies to version 10 and later databases. For information about these values, see Collation tailoring options.

Checkpoint urgency   Shows the time that has elapsed since the last checkpoint, as a percentage of the checkpoint time setting of the database. Click Refresh or press F5 to update the Checkpoint Urgency and Recovery Urgency values. See CheckpointUrgency database property.

Recovery urgency   Shows an estimate of the amount of time required to recover the database, as a percentage of the recovery urgency setting of the database. Click Refresh or press F5 to update the Checkpoint Urgency and Recovery Urgency values. See RecoveryUrgency database property.

Collect information for deadlocks that occur on this database   Select this option to record information about deadlocks that occur in this database. To view the collected deadlock information, select the database in the Folders view in the left pane, and then select the Deadlocks tab in the right pane.

Clear deadlock information now   Click Clear Deadlock Information Now to clear the deadlock information immediately.