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" <christopher.jo...@oracle.com> ??????:49500cc3.8090...@oracle.com... > > 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: christopher.jo...@oracle.com Tel: +1 650 506 8630 > Twitter: http://twitter.com/ghrd Free PHP Book: > http://tinyurl.com/UGPOM > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php