#38972 [Fbk->Opn]: OCI-Lob->loa return broken character
| From: | masui at emplex dot co dot jp | Date: | Wed, 27 Sep 2006 11:31:39 +0000 |
| Subject: | #38972 [Fbk->Opn]: OCI-Lob->loa return broken character | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-102808@lists.php.net to get a copy of this message | ||
ID: 38972
User updated by: masui at emplex dot co dot jp
Reported By: masui at emplex dot co dot jp
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: linux
PHP Version: 5.2.0RC4
New Comment:
Can your CLOB data be returned by reproduce code correct?
Previous Comments:
------------------------------------------------------------------------
[2006-09-27 11:25:29] tony2001@php.net
So, what's the problem then?
------------------------------------------------------------------------
[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] tony2001@php.net
...which is exactly what you posted earlier:
"My CLOB data in Oracle is
"�Zˆê“ñŽOŽlŒÜ˜ZŽµ”ª‹ã"."
------------------------------------------------------------------------
[2006-09-27 11:01:55] tony2001@php.net
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] tony2001@php.net
Just insert plain Unicode data and select it from the table.
------------------------------------------------------------------------
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