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 -> Re: howto find out the database character set

Re: howto find out the database character set

From: Tim Lange <tlange_at_execpc.com>
Date: Mon, 30 Oct 2000 16:00:21 -0600
Message-ID: <8tkqi0$6q63@news.abbott.com>

select * from nls_database_parameters

should show the character set and the NCHAR character set.

bonminh lam wrote in message <39FDF35A.401219DD_at_online.de>...
>Suppose you were to enherit a database as an DBA and you suspect the
>database was created with US 7 bit ascii, how could you verify that? The
>reason is that users can not insert German special characters into to an
>VARCHAR2 field. The NLS_LANGUAGE parameter in the INITSID.ORA is not the
>solution because changing it (per session) to GERMAN does not help. Does
>one have to fear the worst? i.e, recreate the database to fix the
>problem?
>
>There seems to be no dictionary view that tells which character set the
>DB was created with. But I'd be delighted to be proved wrong.
>
>--
>To reply to me via email, please substitute the text no_spam
>with mailbox in the return address.
Received on Mon Oct 30 2000 - 16:00:21 CST

Original text of this message

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