Re: DBI-Link, Oracle, database encoding - Mailing list pgsql-general

From David Fetter
Subject Re: DBI-Link, Oracle, database encoding
Date
Msg-id 20061027182706.GI24218@fetter.org
Whole thread Raw
In response to Re: DBI-Link, Oracle, database encoding  ("Albe Laurenz" <all@adv.magwien.gv.at>)
List pgsql-general
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 :^)

Great :)

> >> NLS_LANG need to be set in the environment of the process using
> >> the Oracle client.
> >
> > Is there some way to set this in the connection string for DBI?
>
> You, the author of DBI-Link, know more about DBI than I do.

Not necessarily.  This is a Perl and Oracle issue.  DBI-Link just uses
DBI's facilities without further elaboration.

> My guess: No.
> You cannot pass the desired codepage to Oracle client at connect
> time.

Good to know.

> The only possible way to tell Oracle client what codepage you want
> is with the environment variable NLS_LANG. Also, you cannot change
> the client codepage during a session. Don't ask me why they designed
> it that way.

I'm sure it seemed like a good idea at the time ;)

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

pgsql-general by date:

Previous
From: Richard Troy
Date:
Subject: Re: [SQL] Can we convert from Postgres to Oracle !!???
Next
From: Alvaro Herrera
Date:
Subject: Re: Mailing list problem?