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: Changing the server-charset from USASCII7 to WE8ISO8859P1 possible?

Re: Changing the server-charset from USASCII7 to WE8ISO8859P1 possible?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Mar 2001 18:55:14 +0200
Message-ID: <tbutvrp3hcek2c@beta-news.demon.nl> 







"Rafal Jank" <yankee_at_wp-sa.pl> wrote in message
news:3ABF3272.C5C23B40_at_wp-sa.pl...


> > I've already tried to shutdown the DB, change

> > $NLS_LANG to AMERICAN.WE8ISO8859P1 before startup,

> > but this didn't help :(.

> I'm affraid you can't change database character set after creating the

> instance...

> Rafal




Incorrect for 8i and higher.


The alter database command has an option to change the characterset.
On 8.0 and before you will be forced to recreate the database.



Hth,



Sybrand Bakker, Oracle DBA
Received on Mon Mar 26 2001 - 10:55:14 CST












Original text of this message













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