Re: Oracle 10g / PHP / utf-8

Nico wrote:
> 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.
>>

That's an understatement, see links below.

>
> 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 ?

Make that AMERICAN_AMERICA.AL32UTF8 (as stated by Laurenz). Also check these links:
http://www.mail-archive.com/unicode@unicode.org/msg17884.html (+subsequent replies!)
http://forums.oracle.com/forums/thread.jspa?threadID=343349 where you also will find a link to a 14-page Oracle Whitepaper on Oracle's Unicode support.

HTH

-- 
Jeroen