Re: oracle replaces ISO-8859-1 characters with question marks

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 26 Feb 2005 11:06:09 +0100
Message-ID: <nei021l45rv4bsme0imkhs94bgc5nh4bn3@4ax.com>

On 24 Feb 2005 14:23:26 -0800, noah_at_noah.org wrote:

>It was a client issue. Everything worked from the command-line sqlplus
>when I set the environment variable:
> export NLS_LANG=american_america.WE8ISO8859P1
>It's strange that Oracle didn't set this up along with all the other
>environment
>variables it configured during the install. Maybe someone in our
>organization deleted it from the environment.
>
>I'm accessing the database from PHP so I have to set the NLS_LANG
>environment variable before I start Apache.
>
>Yours,
>Noah

You can distinguish between a database issue and a client issue by using the DUMP function in your SELECT.

Jaap. Received on Sat Feb 26 2005 - 04:06:09 CST