Re: DBI-Link, Oracle, database encoding

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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!