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