From: Chaun Keating <scubadog11@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Ora2Pg and export of Multbyte UTF8 characters
Date: Fri, 14 Jul 2006 11:29:00 -0700 (PDT)
Message-ID: <20060714182900.12887.qmail@web55710.mail.re3.yahoo.com> (raw)
In-Reply-To: <44B7C17E.7080901@andycc.net>
Ah, I've actually run into this problem before. Seems
I'd forgotten to explicitly set the NLS_LANG parameter
in the Ora2Pg script. Once I set it to
AMERICAN_AMERICA.UTF8 it seems to work just dandy.
--- Andy Shellam <andy@andycc.net> wrote:
> 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!
> >
> >
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will
> ignore your desire to
> choose an index scan if your joining column's
> datatypes do not
> match
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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: scubadog11@yahoo.com
Subject: Re: Ora2Pg and export of Multbyte UTF8 characters
In-Reply-To: <20060714182900.12887.qmail@web55710.mail.re3.yahoo.com>
References: <44B7C17E.7080901@andycc.net> <20060714182900.12887.qmail@web55710.mail.re3.yahoo.com>
* 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