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

howto find out the database character set

From: bonminh lam <mailbox_at_online.de>
Date: Mon, 30 Oct 2000 23:16:58 +0100
Message-ID: <39FDF35A.401219DD@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:16:58 CST

Original text of this message

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