Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: character set?

Re: character set?

From: news.xtra.co.nz <sohosoho_at_ZEROSPAMhotmail.com>
Date: Thu, 10 May 2001 21:04:42 +1200
Message-ID: <fQsK6.195$ia.22286@news.xtra.co.nz>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US