Search Postgresql Archives

Re: DBI-Link, Oracle, database encoding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Remember to vote!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux