Database properties listed on this tab cannot be changed without rebuilding the database.
See Rebuilding databases.
The Settings tab of the Database property sheet has the following components:
Encryption type Shows whether or not the database is encrypted, and the type of encryption, which is either Simple, AES, or AES_FIPS. If encryption is not supported in the database, None appears.
For information about the types of encryption supported by SQL Anywhere, see Encrypting a database.
Encryption scope Shows the level of encryption specified. The possible values are None, Table, or Database. If the setting is Table, you can mark specific tables for encryption. If the setting is Database then the entire database is encrypted.
Case sensitive 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. This property applies to version 10 and earlier databases. See Case sensitivity.
Ignore trailing blanks Shows whether the database ignores trailing blanks in comparisons.
Collation sequence 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. This property applies to pre-version 10 databases. See Understanding collations.
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. For a description of 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. For a description of 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 value.
Recovery urgency Shows an estimate of the amount of time required to recover the database. Click Refresh or press F5 to update the Recovery urgency value.
Refresh Click Refresh to update the checkpoint urgency and recovery urgency values.
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 tree view in the left pane, and then select the Deadlocks tab in the right pane. See Viewing deadlocks from Sybase Central.
Include SQL statement information for deadlocked connections Select this option to record the SQL statement information for deadlocks that occur on this database. This option is only available if Collect Information for Deadlocks That Occur on This Database is selected.
Clear deadlock information now Click Clear Deadlock Information Now to clear the deadlock information right away.