#38972 [Opn->Fbk]: OCI-Lob->loa return broken character
| From: | tony2001@php.net | Date: | Wed, 27 Sep 2006 11:40:47 +0000 |
| Subject: | #38972 [Opn->Fbk]: OCI-Lob->loa return broken character | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-102809@lists.php.net to get a copy of this message | ||
ID: 38972
Updated by: tony2001@php.net
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:
Yes, with your code I get valid Unicode data I inserted before.
Please try to run it in console (but don't forget to set NLS_LANG
first).
Previous Comments:
------------------------------------------------------------------------
[2006-09-27 11:31:39] masui at emplex dot co dot jp
Can your CLOB data be returned by reproduce code correct?
------------------------------------------------------------------------
[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Žµ”ª‹ã"
------------------------------------------------------------------------
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