Re: character set

Try using this:

When a database is created, then you have to set up the correct character set. If not specified, then it will be impossible to enter 8-bit characters. It will only be possible to enter 7-bit characters and not danish characters.

First find out which values are the current for the database. Use SQL*Plus, connected as user sys:
set array 1
select *from sys.props$;
select *from sys.props$ where NAME = 'NLS_CHARACTERSET';

To find the legal values, use this statement: select distinct value from v$nls_valid_values where parameter = 'CHARACTERSET'; Then update the data dictionary:
update props$ set VALUE$ = 'WE8ISO8859P1' where NAME = 'NLS_CHARACTERSET';

Then shut down and restart the database. The vary carefully to enter correct information, because wrong information can corrupt the database (make it impossible to restart).

Best regards

Karsten Weikop
Make IT, Denmark, Europe

Amy Davidson skrev i meddelelsen <7ah5kl$e59$1_at_nslave1.tin.it>...
>How do I determine what the character set is
>of my database?
>
>A create database statement looks something like this:
>
>create database test
> logfile 'c:\orant\database\test\log1test.ora' 200K,
> 'c:\orant\database\test\log2test.ora' 200K
>datafile 'c:\orant\database\test\systest.ora' 30M
>maxdatafiles 50
>character set WE8ISO8859P1
>noarchivelog;
>
>I have a database that I did not create and I need to know
>if it is US7ASCII or we8iso8859p1. Is there a data dictionary
>that can give me this info?
>
>Regards,
>Amy
>
>
>
Received on Thu Feb 18 1999 - 09:23:48 CST