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 D79729FAD5A for ; Fri, 14 Jul 2006 15:35:52 -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 29958-06 for ; Fri, 14 Jul 2006 15:35:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web55710.mail.re3.yahoo.com (web55710.mail.re3.yahoo.com [216.252.110.41]) by postgresql.org (Postfix) with SMTP id CD7749FAC76 for ; Fri, 14 Jul 2006 15:35:48 -0300 (ADT) Received: (qmail 12889 invoked by uid 60001); 14 Jul 2006 18:29:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=czYd4Xk6LF1YW6hwq8w/ZniqczJBVa2BO56Ida0ieJ2FKX1j2YCGmeyGZQ1c7QwIL9UxDZtylawOlq+lS7IEYYQAapAyuAlfqsRB2j5M8Dm2SjTnA8SNzyctxR1alDToEQ469WWMJtKuSOWgu/bjNzakJPUK8PbHeF8VvvIZoTA= ; Message-ID: <20060714182900.12887.qmail@web55710.mail.re3.yahoo.com> Received: from [12.159.70.154] by web55710.mail.re3.yahoo.com via HTTP; Fri, 14 Jul 2006 11:29:00 PDT Date: Fri, 14 Jul 2006 11:29:00 -0700 (PDT) From: Chaun Keating Subject: Re: Ora2Pg and export of Multbyte UTF8 characters To: pgsql-admin@postgresql.org In-Reply-To: <44B7C17E.7080901@andycc.net> 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.244 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_WHOIS, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: X-Archive-Number: 200607/120 X-Sequence-Number: 22366 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 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: > > >

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 > > > > ---------------------------(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