Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to determine CHARACTER SET of Oracle 8 database

How to determine CHARACTER SET of Oracle 8 database

From: <johnvue_at_gte.net>
Date: Sat, 11 Jul 1998 00:51:32 GMT
Message-ID: <6o6d0v$p6u$1@news-2.news.gte.net>


I can issue the following query to find out the CHARACTER SET of an Oracle 7.x database.

 select substr(value$, 1, 17) as nls_characterset  from props$
 where name = 'NLS_CHARACTERSET';

However, the props$ table is not in Oracle 8. How do I get this information in Oracle 8? Received on Fri Jul 10 1998 - 19:51:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US