Re: Oracle 10g / PHP / utf-8
Date: Thu, 20 Nov 2008 11:02:54 -0800 (PST)
Message-ID: <abeff470-ba32-4f18-a649-64a5507fe611@l14g2000yqj.googlegroups.com>
On Nov 20, 5:17 pm, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> Nico <nicodenb..._at_yahoo.com> wrote:
> > On Linux/Apache/PHP5/Oracle Database 10g Express Edition Release
> > 10.2.0.1.0 I checked the script /usr/lib/oracle/xe/app/oracle/product/
> > 10.2.0/server/config/scripts/sqlplus.sh, where the environment var
> > NLS_LANG is set to AMERICAN.UTF8. So far so good. It means that the
> > client was properly configured.
>
> Oracle's UTF8 is in UNICODE Version 3.0
> Oracle's AL32UTF8 is UNICODE Version 4.01
>
> The latter is preferred.
>
Laurenz; As I wrote, from PHP I do not set the language, but only the charset - to AL32UTF8. So in PHP we're OK.
If I understand correct, for sqlplus or other client software, I should set the environment var NLS_LANG to AMERICAN.AL32UTF8 ?
Thank you Laurenz for your feedback!
Kind regards, Nico Received on Thu Nov 20 2008 - 13:02:54 CST