Re: DBI-Link, Oracle, database encoding

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: DBI-Link, Oracle, database encoding
Дата
Msg-id 52EF20B2E3209443BC37736D00C3C1380B27A2B5@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на DBI-Link, Oracle, database encoding  (Hannes Dorbath <light@theendofthetunnel.de>)
Ответы Re: DBI-Link, Oracle, database encoding  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: "Willy-Bas Loos"
Дата:
Сообщение: Re: password cookie
Следующее
От: "Coder At Heart"
Дата:
Сообщение: Re: Reducing pg_dump & pg_restore times