Skip site navigation (1) Skip section navigation (2)

Re: Ora2Pg and export of Multbyte UTF8 characters

From: Andy Shellam <andy(at)andycc(dot)net>
To: Chaun Keating <scubadog11(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Ora2Pg and export of Multbyte UTF8 characters
Date: 2006-07-14 16:08:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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&#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 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> !DSPAM:14,44b7bf7434536342414476!

In response to


pgsql-admin by date

Next:From: Aaron BonoDate: 2006-07-14 17:43:24
Subject: Re: *** How can I install two postgresqls in the same machine? *****
Previous:From: Chaun KeatingDate: 2006-07-14 15:42:18
Subject: Ora2Pg and export of Multbyte UTF8 characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group