Ora2Pg and export of Multbyte UTF8 characters

From: Chaun Keating <scubadog11(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Ora2Pg and export of Multbyte UTF8 characters
Date: 2006-07-14 15:42:18
Message-ID: 20060714154218.10234.qmail@web55703.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, I have gotten Ora2pg to work fairly well for
me, but I am having an issue where mutibyte characters
are being substituted with replacement characters on
export from Oracle.

I used both the output to a file and the direct import
to a PG database and see a bunch of question marks
instead of my multibyte chars.

I have pulled text directly from each database using
the exact same DBD::Oracle and DBD::Pg modules and the
Oracle set displays the multibytes appropriately, so I
believe I have elminated that module as a potential
problem.

The oracle characters from the original table look
fine when I select from the table. An example (which
may or may not come through correctly for everyone) is
as follows:
<p>16&#12434;&#22522;&#25968;&#12392;&#12375;&#12383;&#25968;&#12290;16&#36914;&#25968;&#12391;&#12399;&#12289;0&#65374;9&#12414;&#12391;&#12398;&#26689;&#25968;&#23383;&#12434;&#36890;&#24120;&#12393;&#12362;&#12426;<p>

The postgres characters from the destination table
look like:
<p>16????????16?????0?9????????????????????????<p>

Any hints as to what I need to do to get them
corrected. When I output to a flat file it appears as
though the question marks are in the flat file so
something on export seems to be getting corrupted.

Thanks,
Chaun

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-07-14 16:08:30 Re: Ora2Pg and export of Multbyte UTF8 characters
Previous Message Jonah H. Harris 2006-07-14 15:08:05 Re: hooks for User login process