X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5469E9FB35D for ; Fri, 14 Jul 2006 12:58:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 37893-01 for ; Fri, 14 Jul 2006 12:58:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web55703.mail.re3.yahoo.com (web55703.mail.re3.yahoo.com [216.252.110.34]) by postgresql.org (Postfix) with SMTP id 063689FB35B for ; Fri, 14 Jul 2006 12:58:15 -0300 (ADT) Received: (qmail 10236 invoked by uid 60001); 14 Jul 2006 15:42:18 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=UWWxo712MfUo6df+odgO/POWJNK0zn1Dla9RdzHQyC7TFb6Bf1fA4v2Oh6wI5+QPDZNY3+G6Xq765LSeYm5fUgjJnV/bIXXndxYODgZFqt+CYdAiBGWdD1c2jpb+/Nue02uSyY8a1a19UKKTMlF0EE/7CxV93NhkhsjD9JSCnec= ; Message-ID: <20060714154218.10234.qmail@web55703.mail.re3.yahoo.com> Received: from [12.159.70.154] by web55703.mail.re3.yahoo.com via HTTP; Fri, 14 Jul 2006 08:42:18 PDT Date: Fri, 14 Jul 2006 08:42:18 -0700 (PDT) From: Chaun Keating Subject: Ora2Pg and export of Multbyte UTF8 characters To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.606 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_WHOIS, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: X-Archive-Number: 200607/117 X-Sequence-Number: 22363 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:

16を基数とした数。16進数では、0~9までの桁数字を通常どおり

The postgres characters from the destination table look like:

16????????16?????0?9????????????????????????

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