pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 



view thread (3+ messages)

Message-ID: <20060714182900.12887.qmail@web55710.mail.re3.yahoo.com>
Permalink:  ../20060714182900.12887.qmail@web55710.mail.re3.yahoo.com/
Also on:    postgresql.org/message-id/20060714182900.12887.qmail@web55710.mail.re3.yahoo.com

 · 

reply

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