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.
Try 'AL32UTF8'.
The oracle db has to be set up to allow those sort of chars too when you
create it, you can't convert it (everything I found says you have to do
a dump/recreate the db/import the data).
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
