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: Mon, 13 Jul 1998 09:34:41 GMT
Message-ID: <6ockc2$od0$3@news-1.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 Mon Jul 13 1998 - 04:34:41 CDT

Original text of this message

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