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: BVB <bart.van.den.bosch_at_ordab.com>
Date: Wed, 17 Jan 2001 16:11:24 GMT
Message-ID: <979747884.269917@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:11:24 CST

Original text of this message

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