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: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

From: joel garry <joel-garry_at_home.com>
Date: Wed, 25 Jul 2007 13:47:12 -0700
Message-ID: <1185396432.142010.9830@x40g2000prg.googlegroups.com>


On Jul 23, 1:11 am, codadilupo <codadil..._at_operamail.com> wrote:
> joel garry wrote:
> > Previous threads here by Frank, and several notes on metalink have
> > clues how to fix this. Not out of luck, just need to work it out.
> > There is a character conversion utility which includes a way to figure
> > out how bad the problem is. But Gerrit, and anyone else using
> > US7ASCII should fix the database character set sooner rather than
> > later.
>
> Joel,
>
> may you give us some references about how to fix this problem?
>
> Thank you. Kind regards,
>
> --
> CdL

Start with metalink Note:15095.1 and its references, and Note: 227330.1.

The general answer is to do things to be sure the character set is the same in all environments when running exp/imp, even if you have to fool Oracle in some cases. Since there are so many possibilities of versions and charactersets, I would recommend exporting a very small amount of data that includes your range of 8-bit examples, and importing into a db with the proper characterset to be sure you understand what happens. That's certainly better than trusting my capricious memory as to which way works on which version.

Of course, the csscan (search for it on tahiti.oracle.com) may show it to be a non-issue or small enough to just update with scripts, and the flat-file/sqlloader will likely work without much thought.

jg

--
@home.com is bogus.
02299, 00000,"cannot validate (%s.%s) - duplicate keys found"
// *Cause: an alter table validating constraint failed because the
table has
//      duplicate key values.
// *Action: Obvious
Received on Wed Jul 25 2007 - 15:47:12 CDT

Original text of this message

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