php-i18n Digest 7 Apr 2002 14:55:09 -0000 Issue 106
Topics (messages 251 through 252):
Re: Beginner needs a step up..
251 by: Boaz
PHP4, Oracle 8i and UTF-8
252 by: Von Bundermuft
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hi Robert,
I've been working on a multi lingual project for the last two months, with
SUN OS and Informix DB server.
As far as I can see there is no problem (with Informix) to store information
in all languages (I'm currently using 12 languages - English and most
European, Chinese, Japanese and Hebrew).
The only thing that is very important is to set the codepage of your input
HTML page to the right one.
I'm using iso-8859-1 for English and European languages, UTF-8 for Chinese
and Japanese and iso-8859-8-i for Hebrew.
I hope it will be useful.
Boaz.
"Robert Earls" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am having a great deal of difficulty understanding all the issues
> involved in making my current project completely i18n.
> Currently it is multilingual for western European languages only, i.e
> English, French etc. But now I need to make it work for Arabic Greek
etc..
> All the language is currently stored in an Oracle database, and all
> translations are done on the fly. Which works quite well.
>
> Has anyone been through this process and would be willing to share
> information and/or resources. Not just in PHP but HTML as well.
>
> I would be very happy to hear from anyone at all. This list might be
> quiet, but it's my best hope!!
>
> Rob
>
--- End Message ---
--- Begin 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
--- End Message ---
