Re: [PHP-DB] oci_connect returns warning if provided with the 4th param(charset)
[email protected] ("Tonado")
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Hi Chris,
Thank you very much for the info. I found that there wasn't a library
called 'libociei.so' on my server compared with the lastest Oracle Instant
Client. I copied it to my server and then I found oci_connect(,,,'UTF8')
worked! I didn't know why but I thought you were right that my prior OCI
just supported a restricted set of character set. Thank you very much!
Regards,
Tonado
"Christopher Jones" <[email protected]>
??????:[email protected]...
>
> Tonado wrote:
> > Hi all,
> >
> > I used the following in my code
> > ....
> > oci_connect('$user','$pass',$connectionString,'UTF8');
> > ....
> >
> > and got the following warning:
> >
> > Warning: oci_connect() [function.oci-connect]: Invalid character set
> > name: UTF8
> > I tried many times and found it could only work when I removed
> > 'UTF8' or replaced it with 'US7ASCII'. It didn't work even I used
> > 'WE8ISO8859P1'. But I had to use 'UTF8' in order to support multiple
> > bytes. I had tried setting NLS_LANG to AMERICAN_AMERICA.UTF8 in
> > envvars instead of using the 4th parameter in oci_connect, but it
> > didn't work. Using putenv to set NLS_LANG didn't work either.
>
> Did you build PHP with Oracle XE libraries?
>
> Some versions of Oracle libraries support a restricted set of
> character sets to reduce size. For example, Oracle Instant Client
> Basic Lite has only English error messages and Unicode, ASCII, and
> Western European character set support.
>
> Oracle XE comes in two bundles, one supporting only the character set
> WE8MSWIN1252, the other AL32UTF8. See
> http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm#BABJACJJ
>
> Oracle's general name for UTF8 is AL32UTF8. A list of character set
> names is at:
> http://download.oracle.com/docs/cd/B28359_01/server.111/b28298/applocaledata.htm#i635047
>
> > Does anyone encounter this weird issue before? The php version I'm
> > using is 5.2.1.
>
> PHP 5.2.1 is old now, and there have been many updates. If possible
> upgrade PHP.
>
> For all 5.2.x versions (including 5.2.8) I would upgrade at least the
> OCI8 extension to version 1.3. See http://pecl.php.net/package/oci8
> Instructions are in http://tinyurl.com/UGPOM
>
> Chris
>
> --
> Email: [email protected] Tel: +1 650 506 8630
> Twitter: http://twitter.com/ghrd Free PHP Book:
> http://tinyurl.com/UGPOM
>