| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> howto find out the database character set
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
![]() |
![]() |