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
