ASA Database Administration Guide
  International Languages and Character Sets
    International language and character set tasks

Determining locale information

You can determine locale information using system functions.

For more information, see System functions.

To determine the locale of a database server

1. Start Interactive SQL, and connect to a database server.

2. Execute the following statement to determine the database server character set:

   SELECT PROPERTY( 'CharSet' )

   The query returns one of the supported character sets listed in Character set labels.

3. Execute the following statement to determine the database server language:

   SELECT PROPERTY( 'Language' )

   The query returns one of the supported languages listed in Language label values.

4. Execute the following statement to determine the database server default collation:

   SELECT PROPERTY( 'DefaultCollation' )

   The query returns one of the collations listed in Choosing collations.

Notes 

To obtain client locale information, connect to a database server running on your current machine.

To obtain the character set for an individual database, execute the following statement:

SELECT DB_PROPERTY ( 'CharSet' )