TOD – What a character(set)! August 5, 2008
Posted by grumpydba in general, Tip 'o the day.Tags: characterset nchar_characterset, NLS
add a comment
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
