RDBMS Information - Common to all RDBMS - Get the character set

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

Applicable RDBMS

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