Posts Tagged NLS
TOD – What a character(set)!
Posted by Jay Caviness in Tip 'o the day, general on August 5th, 2008
Is it UTF8, us7ascii, western European? I have always wished that I should just do a “show parameter” to get the character set, but alas, ’tis not so. Here is a Q&D script to find what characterset you are using:
col parameter for a30
col value for a20
select * from nls_database_parameters
where parameter in ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET')
order by parameter;
PARAMETER VALUE
------------------------------ --------------------
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16