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

Home -> Community -> Usenet -> c.d.o.server -> Re: change character set i Oracle 7.3.2

Re: change character set i Oracle 7.3.2

From: Anders Blomkvist <anders.blomkvist_at_nokia.com>
Date: Wed, 17 Jan 2001 16:17:18 GMT
Message-ID: <iAj96.20634$oL4.427350@news2.nokia.com>

Hmm, do i still have to drop the database and change the charset in oracle?

/Anders

"BVB" <bart.van.den.bosch_at_ordab.com> wrote in message news:979747884.269917_at_localhost...
>
> Before importing the dump file, change its third byte (with a hex-editor)
> from $01 (code for US7ASCII) to $1F (WE8ISO8859P1).
> The exp and imp parameters doesn't matter.
>
> Bart
>
>
> Anders Blomkvist <anders.blomkvist_at_nokia.com> wrote in message
> news:Uxi96.20620$oL4.427327_at_news2.nokia.com...
> > What is the best way to change character set i an Oracle v7.3.2 database
> > from US7ASCII to WE8ISO8859P1?
> > I am pretty sure about the procedure:
> >
> > 1) Export data
> > 2) Drop database
> > 3) Create basic database with new character set
> > 4) Import data
> >
> > But how should the exp command look like?
> >
> >
>
>
Received on Wed Jan 17 2001 - 10:17:18 CST

Original text of this message

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