Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: character set?
ive only a small database on my development and its nothing i cant rebuild
alter database peace character set American_America.US7ASCII;
?
from sqlplus
(am running windows 2k server and oracle 8ix)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:tfkkksqta7vvdc_at_beta-news.demon.nl...
> 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 - 04:04:42 CDT