Re: php oracle10

On 20 Apr 2006 09:52:44 -0700, "prunoki" <hegyvari_at_ardents.hu> wrote:

>Hi,
>
>After migrating from the "big" oracle client to instant client, the
>letters with accent does not appear in my web application. I use PHP to
>generate the web pages.
>
>The database server nls_lang is american_america.ee8iso8859p2. This was
>set on my Fedora Core as an environment variable and everything worked.
>With instant client, this nls_lang env variable is obsolete, I
>understand it is not used anymore. How to set up instant client to do
>the same conversion, thus enabling the letters with accents to appear
>again?
>
>Regards,
>
>Hegyvari Krisztian

Not using the instant client, it occurs to me Oracle may have stripped this down compared to the full client. It wouldn't surprise me if they removed the NLS libraries: those account for most of the disk space used.
You did verify the impact of using the instant client instead of the full client, didn't you? Or did you just think: small is better, and went ahead without reading?
Anyway: your conversion was dependent on NLS_LANG. If NLS_LANG is gone this means no conversion.

--
Sybrand Bakker, Senior Oracle DBA