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@xxxxxxxxxx> 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
