Locale Information - Sybase SQL Anywhere

You can use the following queries to obtain the locale information from Sybase SQL Anywhere database server:

Sybase ASA:

   -- Get the character set of the database server
   SELECT PROPERTY('CharSet');
   # windows-1252
 
   -- Get the character set used to store CHAR data in the database
   SELECT DB_PROPERTY('CharSet');
   # windows-1252
 
   -- Get the character set used to store NCHAR data in the database
   SELECT DB_PROPERTY('NcharCharSet');
   # UTF-8
 
   -- Get the client's character set used to store CHAR data
   SELECT CONNECTION_PROPERTY('CharSet');
   # windows-1251
 
   -- Get the client's character set used to store NCHAR data
   SELECT CONNECTION_PROPERTY('NcharCharSet');
   # UTF-8

For more information, see Sybase SQL Anywhere Reference.