You can determine locale information using functions such as PROPERTY, DB_PROPERTY, and CONNECTION_PROPERTY. The following table shows how to use these functions to return locale information about the client connection, database, and database server.
System function and parameter | Return value | ||
---|---|---|---|
|
Character set of the database server. Usually the character set of the computer hosting the database server. | ||
|
Default CHAR collation used by the database server for creating databases. | ||
|
Default NCHAR collation used by the database server for creating databases. | ||
|
The locale language for the database server. | ||
|
Character set used to store CHAR data in the database. | ||
|
Character set used to store NCHAR data in the database. | ||
|
Whether CHAR data uses a multibyte character set (On=yes, Off=no). | ||
|
Comma-separated list of two-letter codes representing the languages supported by database CHAR collation. | ||
|
CHAR collation name in use by the database server. | ||
|
NCHAR collation name in use by the database server. | ||
|
Client's CHAR data character set. | ||
|
Character set of NCHAR data for the connection. | ||
|
Client language for the connection. |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |