From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
---|---|
To: | "David Fetter *EXTERN*" <david(at)fetter(dot)org> |
Cc: | "Hannes Dorbath *EXTERN*" <light(at)theendofthetunnel(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DBI-Link, Oracle, database encoding |
Date: | 2006-10-27 07:05:44 |
Message-ID: | 52EF20B2E3209443BC37736D00C3C1380B27A2B5@EXADV1.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Coder At Heart | 2006-10-27 07:26:51 | Re: Reducing pg_dump & pg_restore times |
Previous Message | Willy-Bas Loos | 2006-10-27 07:01:41 | Re: password cookie |