About

Martin Klier

usn-it.de

Find out your character set in Oracle DB

Hi,

since ‘show parameter’ does not tell you your database charset, use this statement to see how your characters are stored:

select * from nls_database_parameters 
where parameter='NLS_CHARACTERSET';

Regards
Usn

Talk “Hope is not a strategy” at Vocational School Wiesau
Disabling (or enabling) general job execution in Oracle 10g

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.