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

From Albe Laurenz
Subject Re: DBI-Link, Oracle, database encoding
Date
Msg-id 52EF20B2E3209443BC37736D00C3C1380B27A2B5@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to DBI-Link, Oracle, database encoding  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: DBI-Link, Oracle, database encoding  (David Fetter <david@fetter.org>)
List pgsql-general
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 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.
My guess: No.
You cannot pass the desired codepage to Oracle client at connect
time.
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.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Willy-Bas Loos"
Date:
Subject: Re: password cookie
Next
From: "Coder At Heart"
Date:
Subject: Re: Reducing pg_dump & pg_restore times