Determining locale information

You can determine locale information using system functions.

For a complete list, see the Sybase IQ Reference Manual.

Start DBISQL, and connect to a database server.

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”.
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”.
Execute the following statement if you need to determine a good alternative to the default collation, ISO_BINENG:
```
SELECT PROPERTY( 'DefaultCollation' )
```
The query returns one of the collations listed in “Supplied and recommended collations”.

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' )