Edit report at https://bugs.php.net/bug.php?id=70700&edit=1
ID: 70700
Updated by: sixd@php.net
Reported by: ashnazg@php.net
Summary: LOB read loop ends early for multibyte strings
-Status: No Feedback
+Status: Feedback
Type: Bug
Package: OCI8 related
Operating System: RHEL6, Win7
PHP Version: 5.5.30
Assigned To: sixd
Block user comment: N
Private report: N
New Comment:
If you are using multibyte characters you will almost certainly want NLS_LANG set. It is just an
environment variable, so you can 'echo' it, and/or check phpinfo(), or run php -i,
Review http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html
Previous Comments:
------------------------------------------------------------------------
[2015-10-29 15:36:55] ashnazg@php.net
The bugtracker will not allow me to change the status to ReOpened.
I am indeed still having this problem. In my last comment, I asked for a way to determine the
answer to your question about "client NLS_LANG".
Is running the PHPT test I provided not an option to see if you can duplicate the issue?
------------------------------------------------------------------------
[2015-10-25 04:22:30] php-bugs at lists dot php dot net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
------------------------------------------------------------------------
[2015-10-14 21:42:05] ashnazg@php.net
I can't seem to google a way to determine client NLS_LANG...
The only examples I see are from in sqlplus:
SQL> !
$ echo $NLS_LANG
but that returns nothing. Perhaps that means my client is not setting it?
(also, that's good to know that OCI8 doesn't cover N-stuff either... was only aware of PDO
OCI not handling it)
------------------------------------------------------------------------
[2015-10-14 05:38:18] sixd@php.net
What's the client NLS_LANG?
Neither OCI8 or PDO_OCI support NCHAR / NCLOB.
------------------------------------------------------------------------
[2015-10-13 15:05:25] ashnazg@php.net
My environments:
RHEL6:
- PHP 5.5.24
- oci8 => 1.4.10
- Oracle Run-time Client Library Version => 11.2.0.3.0
- Oracle Instant Client Version => 12.1
- Temporary Lob support => enabled
Win7:
- PHP 5.5.11
- oci8 => 1.4.10
- Oracle Run-time Client Library Version => 11.2.0.2.0
- Oracle Instant Client Version => 11.2
- Temporary Lob support => enabled
Database:
NLS_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LENGTH_SEMANTICS CHAR
I don't run these multibyte CLOB tests against my older database that uses
WE8MSWIN1252/AL16UTF16, as I've read that PDO OCI doesn't have NCLOB support implemented
(that only affects my OCI8 testing because it's a DBAL/ORM system, and thus I'm trying to
keep the 'available features' matched between OCI8 and PDO OCI).
------------------------------------------------------------------------
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
https://bugs.php.net/bug.php?id=70700
--
Edit this bug report at https://bugs.php.net/bug.php?id=70700&edit=1