ID: 38972
Updated by: [EMAIL PROTECTED]
Reported By: masui at emplex dot co dot jp
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: linux
PHP Version: 5.2.0RC4
New Comment:
So, what's the problem then?
Previous Comments:
------------------------------------------------------------------------
[2006-09-27 11:15:38] masui at emplex dot co dot jp
Yes, your CLOB DATA is correct.
I tested for Japanease UTF-8.
------------------------------------------------------------------------
[2006-09-27 11:02:44] [EMAIL PROTECTED]
...which is exactly what you posted earlier:
"My CLOB data in Oracle is
"�Zˆê“ñŽOŽlŒÜ˜ZŽµ”ª‹ã"."
------------------------------------------------------------------------
[2006-09-27 11:01:55] [EMAIL PROTECTED]
This is what I get back when I insert
UTL_RAW.CAST_TO_VARCHAR2('A3B0A3B1A3B2A3B3A3B4A3B5A3B6A3B7A3B8A3B9'):
string(40)
"�Zˆê“ñŽOŽlŒÜ˜ZŽµ”ª‹ã"
------------------------------------------------------------------------
[2006-09-27 11:00:23] [EMAIL PROTECTED]
Just insert plain Unicode data and select it from the table.
------------------------------------------------------------------------
[2006-09-27 10:53:44] masui at emplex dot co dot jp
I set NLS_LANG in /usr/local/apache2/bin/envvars.
Following is my setting.
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export NLS_LANG=.AL32UTF8
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_PRELOAD=$ORACLE_HOME/lib/libclntsh.so.10.1
I tested by access from web browser.
Following is create table and insert data.
CREATE TABLE LOBTEST (
LOBDATA CLOB
);
insert INTO LOBTEST VALUES
(UTL_RAW.CAST_TO_VARCHAR2('A3B0A3B1A3B2A3B3A3B4A3B5A3B6A3B7A3B8A3B9'));
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/38972
--
Edit this bug report at http://bugs.php.net/?id=38972&edit=1
