Re: Possible characterset issues w/ datapump

  • From: Tony van Lingen <tony.vanlingen@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 22 Jan 2007 10:37:10 +1000

*Datapump would use the database character set I'd suppose, as it is 
really the database writing out the file, just as with database links 
and utl_file. One note explaining all this is Note:158577.1.

The root of the problem would be that your client inserts and retrieves 
data using it's own character set, but datapump uses US7ASCII to 
interpret the data and consequently the extended characters (which don't 
exists in 7-bit ASCII) get mangled. I don't think there's a workaround, 
except re-entering the extended characters after migration...

Cheers,
Tony

*
Phil Singer wrote:
> Don Seiler wrote:
>> We're having an issue where a "ú" character in a varchar2 is being
>> corrupted after being funnelled through datapump.  I'm reluctant to
>> ... 
>
> Three things immediately pop out:
>
> 1)  Your SOURCE characterset is US7ASCII.  Your problem character does 
> not exist in that characterset.  As the DEST characterset is 
> different, a characterset conversion is definitely expected.
>
> 2)  Normally, it is the _client_ which determines the characterset to 
> use (not the database instance).  Data pump complicates matters.
>
> 3)  If all else fails, investigate the ftp.
>
> But if I had a dollar for each character ruined when someone did a 
> client install and forgot to change the client's character set from 
> US7ASCII to WE8ISO8859P1 I wouldn't be dreading the upcoming layoffs 
> at Ford.  I really think the solution is somewhere along those lines.
>
> Somewhere on MetaLink there is a note which actually explains how 
> Oracle manages character sets, but I forget just which note it is.
>
>

-- 
Tony van Lingen
Tech One Contractor
Information Management
Corporate Development Division
Environmental Protection Agency

Ph:     (07) 3234 1972
Fax:    (07) 3227 6534
Mobile: 0413 701 284
E-mail: tony.vanlingen@xxxxxxxxxxxxxx

Visit us online at www.epa.qld.gov.au
--


___________________________
Disclaimer

WARNING: This e-mail (including any attachments) has originated from a 
Queensland Government department and may contain information that is 
confidential, private, or covered by legal professional privilege, and may be 
protected by copyright.  

You may use this e-mail only if you are the person(s) it was intended to be 
sent to and if you use it in an authorised way.  No one is allowed to use, 
review, alter, transmit, disclose, distribute, print or copy this e-mail 
without appropriate authority.  If you have received this e-mail in error, 
please inform the sender immediately by phone or e-mail and delete this e-mail, 
including any copies, from your computer system network and destroy any 
hardcopies.

Unless otherwise stated, this e-mail represents the views of the sender and not 
the views of the Environmental Protection Agency.

Although this e-mail has been checked for the presence of computer viruses, the 
Environmental Protection Agency provides no warranty that all viruses have been 
detected and cleaned. Any use of this e-mail could harm your computer system.  
It is your responsibility to ensure that this e-mail does not contain and is 
not affected by computer viruses, defects or interference by third parties or 
replication problems (including incompatibility with your computer system).

E-mails sent to and from the Environmental Protection Agency will be 
electronically stored, managed and may be audited, in accordance with the law 
and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and 
IS42) to the extent they are consistent with the law.

___________________________

--
//www.freelists.org/webpage/oracle-l


Other related posts: