On Fri, Oct 27, 2006 at 09:05:44AM +0200, Albe Laurenz wrote:
> David Fetter wrote:
> >> I know about Oracle, but have not yet managed to setup DBI-Link.
> >
> > Try it again :)
> > http://pgfoundry.org/projects/dbi-link/
>
> I will try again when the need arises and/or when I find time :^)
Grea
David Fetter wrote:
>> I know about Oracle, but have not yet managed to setup DBI-Link.
>
> Try it again :)
> http://pgfoundry.org/projects/dbi-link/
I will try again when the need arises and/or when I find time :^)
>> NLS_LANG need to be set in the environment of the process using
>> the Oracle
I have it working fine now. Seems PG indeed did not have access to the
env vars, because of the init script I was using.
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_NCHAR=AL32UTF8
pg_ctl restart
fixed it for me.
If you are using DBI-Link, please sign up for its mailing list on
pgfoun
On Wed, Oct 25, 2006 at 03:47:20PM +0200, Albe Laurenz wrote:
> Hannes Dorbath wrote:
> > 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.
> >
>
Hannes Dorbath wrote:
> 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, wh
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::Ora
