DBI-Link, Oracle, database encoding

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: DBI-Link, Oracle, database encoding
Date: 2006-10-25 12:21:51
Message-ID: ehnkmc$1b3j$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After some trouble we managed to get up DBI-Link between PG 8.1.5 and
Oracle 9i.

Oracle is on LATIN1 (I think) and the PG database runs on UTF8. We have
some encoding problems with it.

We tried setting NLS_LANG='american_america.AL32UTF8' for Oracle, which
works for SqlPlus, but not DBD::Oracle (as it seems to me).

Has anyone experience with such a setup? My knowledge on Oracle is limited.

Thanks for any hint.

--
Regards,
Hannes Dorbath

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2006-10-25 12:34:02 Re: [GENERAL] Call for Donations
Previous Message Nick Rowlands 2006-10-25 12:07:01 Re: Difficulty passing in an array of values to EXECUTE