From: Andy Shellam <andy@andycc.net>
To: Chaun Keating <scubadog11@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Ora2Pg and export of Multbyte UTF8 characters
Date: Fri, 14 Jul 2006 17:08:30 +0100
Message-ID: <44B7C17E.7080901@andycc.net> (raw)
In-Reply-To: <20060714154218.10234.qmail@web55703.mail.re3.yahoo.com>
References: <20060714154218.10234.qmail@web55703.mail.re3.yahoo.com>
Is your database and client encoding set to UTF-8?
That's about all I can think of.
Chaun Keating wrote:
> 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を基数とした数。16進数では、0~9までの桁数字を通常どおり<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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> !DSPAM:14,44b7bf7434536342414476!
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy@andycc.net, scubadog11@yahoo.com
Subject: Re: Ora2Pg and export of Multbyte UTF8 characters
In-Reply-To: <44B7C17E.7080901@andycc.net>
References: <20060714154218.10234.qmail@web55703.mail.re3.yahoo.com> <44B7C17E.7080901@andycc.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox