PHP4, Oracle 8i and UTF-8

From: Date: Tue, 02 Apr 2002 22:14:52 +0000
Subject: PHP4, Oracle 8i and UTF-8
Groups: php.i18n 
Request: Send a blank email to php-i18n+get-252@lists.php.net to get a copy of this message
Hi. I have Oracle 8.1.7 installed on Windows box and PHP4.1.2/Apache/Redhat/Oracle8.1.7ClientTools on another. Oracle database has UTF-8 both as charset and national charset. It seems I'm unable to send(and read) correct UTF-8 data as varchar2 to(and from) Oracle database. Sniffing network shows it becomes corrupted already before network trip. I do have NLS_LANG=AMERICAN_AMERICA.UTF8 environment variable set and I'm using OCI* functions to connect Oracle. Does anybody has a solution to this problem or recommends an alternative (changing database or web platform is _not_ an alternative)? Except using binary fields? bmft

« previous php.i18n (#252) next »