Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

Database Properties window: Settings tab

Database properties listed on this tab cannot be changed without rebuilding the database. See Rebuilding databases.

This tab has the following components:

  • 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.

    For information about the supported encryption algorithms, see Encrypting and decrypting a database.

  • 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.

    For information about encrypting databases and tables, see Encrypting and decrypting a database.

  • 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 pre-version 10 databases. See Case sensitivity.

  • 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   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. This property applies to version 10 and later databases. 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. This property applies to version 10 and later databases. 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 Folders 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 immediately.

 See also