Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

NLS_CHARSET - how to get description

unknown-851512Jan 10 2014 — edited Feb 7 2014

My question is how to get description like

  • Cyrillic Windows 1251
  • Eastern European Windows 1250
  • Eastern European ISO-8859-2
  • Unicode UTF-8

from NLS_CHARSET_ID?

You can find complete list of charest descriptions here: http://www.adp-gmbh.ch/ora/misc/globalization.html

I need to add description column to following query but I don't know how:

SELECT nls_charset_id(value) id, value ORA_CHARSET, utl_i18n.map_charset(value) IANA_CHARSET

FROM v$nls_valid_values

WHERE parameter = 'CHARACTERSET';

This post has been answered by User770021-Oracle on Feb 7 2014
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2014
Added on Jan 10 2014
1 comment
1,984 views