 | |
#11
 
| |||
| |||
|
Re: Oracle10 e PHP -
02-26-2009
, 04:40 AM
|
Very strange thing. In my oci_connect I already had the characterset among parameters. "The" characterset? Which one was it? I had UFT8, but I also tried with AL32UTF8. |
Quote:
|
Why do you find this strange? Specifying the character set with the oci_connect is said to speed up connecting. |
disappears.
Perhaps I used the wrong charset: in my DB the charset is AL16UTF16, but I
get an error if I specify it in the oci_connect.
Daniele
#12
| |||
| |||
|
|
"Gerard H. Pille" <ghp (AT) skynet (DOT) be> ha scritto nel messaggio news:49a58b8d$0$2860$ba620e4c (AT) news (DOT) skynet.be... Very strange thing. In my oci_connect I already had the characterset among parameters. "The" characterset? Which one was it? I had UFT8, but I also tried with AL32UTF8. Why do you find this strange? Specifying the character set with the oci_connect is said to speed up connecting. It's strange because, without specifying the character set, the problem disappears. Perhaps I used the wrong charset: in my DB the charset is AL16UTF16, but I get an error if I specify it in the oci_connect. Daniele |
I quote from http://repettas.wordpress.com/2008/0...le-9i-and-10g/ :
"Can You use AL16UTF16 as NLS_CHARACTERSET?
No, AL16UTF16 can only be used as NLS_NCHAR_CHARACTERSET in 9i and above. Trying to create a
database with a AL16UTF16 NLS_CHARACTERSET will fail."
Only NCHAR, NVARCHAR2 and NCLOB columns can use AL16UTF16.
What Oracle Client version are you using? Is the environment variable ORA_NLS33 / ORA_NLS10
correctly set?
#13
| |||
| |||
|
|
It is not nice to lie to people, Daniele. |
Quote:
|
I quote from http://repettas.wordpress.com/2008/0...le-9i-and-10g/ : "Can You use AL16UTF16 as NLS_CHARACTERSET? No, AL16UTF16 can only be used as NLS_NCHAR_CHARACTERSET in 9i and above. Trying to create a database with a AL16UTF16 NLS_CHARACTERSET will fail." |
NLS_NCHAR_CHARACTERSET.
But I didn't lie: the parameters of the DB are:
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
The Oracle 10 DB was installed by a third party, not by me.
I only try to correctly access to data..
Quote:
|
Only NCHAR, NVARCHAR2 and NCLOB columns can use AL16UTF16. What Oracle Client version are you using? Is the environment variable ORA_NLS33 / ORA_NLS10 correctly set? |
PHP with OCI8 Support.
Environment variables ORA_NLS33 / ORA_NLS10 is not set in web server.
But, I repeat, I solved the problem removing characterset parameter from
oci_connect.
Daniele
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.