Re: character set?

I would advice *against* such a short-sighted measure, sorry to say so, as US7ASCII is a *subset* of WE8ISO8859P1, you will *loose* functionality. I would instead change the characterset of the database (in 8i you can do this with an alter database command, no need to rebuild the database). Just to warn you!

Changing it would involve changing NLS_LANG, either as env var (Unixes) or in hkey\local_machine\software\oracle in the registry. The new value is American_America.US7ASCII You will now have effectively *disabled* using national characters!!!!

Hth,

Sybrand Bakker, Oracle DBA

"news.xtra.co.nz" <sohosoho_at_ZEROSPAMhotmail.com> wrote in message news:dNrK6.169$ia.19704_at_news.xtra.co.nz...
> COOL :)
> thats great
> how do i change if from
>
> NLS_NCHAR_CHARACTERSET WE8ISO8859P1
> to the US ASCII character set. ?
>
> bryce
>
>
> > select * from sys.props$
> > or
> > select * from nls_database_parameters
> >
> >
> > The results are determined by the NLS_LANG var in the registry of the
 client
> > computer, or in the registry of the internet server.
> >
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> >
>
>
Received on Thu May 10 2001 - 03:36:38 CDT