PHP4, Oracle 8i and UTF-8
| From: | Von Bundermuft | 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