Purpose
This page help you to get the character set of an RDBMS
For more information, refer to:
- Official documentation refer to Supported Character Sets
Applicable in CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Details
Depending on the RDBMS run one of the following queries:
Query for CSS2
SELECT NAME, setting FROM pg_settings WHERE NAME = 'server_encoding'
Query result example
name setting
---------------- ------------
"server_encoding"; "UTF8"
Query result interpretation
The parameter "server_encoding" have the value "UTF8"
Query for Oracle
SELECT * FROM v$nls_parameters WHERE parameter = 'NLS_CHARACTERSET'
Query result example
PARAMETER VALUE
---------------- ------------
NLS_CHARACTERSET WE8MSWIN1252
Query result interpretation
The parameter NLS_CHARACTERSET have the value WE8MSWIN1252
Notes/comments
Related Pages