ID: 38972
Updated by: [EMAIL PROTECTED]
Reported By: masui at emplex dot co dot jp
Status: Feedback
Bug Type: OCI8 related
Operating System: linux
PHP Version: 5.2.0RC4
New Comment:
This is what I get back when I insert
UTL_RAW.CAST_TO_VARCHAR2('A3B0A3B1A3B2A3B3A3B4A3B5A3B6A3B7A3B8A3B9'):
string(40)
"�Zˆê“ñŽOŽlŒÜ˜ZŽµ”ª‹ã"
Previous Comments:
------------------------------------------------------------------------
[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'));
------------------------------------------------------------------------
[2006-09-27 10:04:45] [EMAIL PROTECTED]
How did you set NLS_LANG? How do you test it?
>Broken is only 64bit Linux only, 32bit linx is ok.
I'm testing on 64bit host and it works perfectly fine with
Oracle10g/UTF8.
------------------------------------------------------------------------
[2006-09-27 09:56:36] masui at emplex dot co dot jp
Yes, I set ".AL32UTF8" to NLS_LANG.
My CLOB data in Oracle is "ZêñOlÜZµªã".
Broken is only 64bit Linux only, 32bit linx is ok.
------------------------------------------------------------------------
[2006-09-27 09:15:34] [EMAIL PROTECTED]
Cannot reproduce.
Make sure your NLS_LANG is set and equals to something similar to
".AL32UTF8".
------------------------------------------------------------------------
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
