Pdo oci, process crashes when charset=utf8 is specified?

Question

PHP

In general, without specifying the encoding, I get such warnings, plus the answer comes in the wrong encoding, respectively, it is not clear what the default is.

PDOStatement::fetchAll(): column 3 data was too large for buffer and was truncated to fit it in

Specified encoding:

$conn = new PDO('oci:dbname=//[host]/orcldb;charset=UTF8',$db_username,$db_password);

php just started crashing, no errors at all, just no response and the process crashes.
I set the oci extension according to this article
Where to dig then? And I would like to understand how to debug such things

Answer 1

In general, I prevented the crash, thanks to AloneCoder for the tip, I set up the environment by adding the following to php-fpm.conf:

env[ORACLE_HOME]=/opt/oracle/instantclient
env[LD_LIBRARY_PATH]=/opt/oracle/instantclient/lib
env[NLS_LANG]="RUSSIAN_RUSSIA.AL32UTF8"
env[NLS_DATE_FORMAT]="YYYY-MM-DD HH24:MI:SS"
env[NLS_LENGTH_SEMANTICS]=CHAR
env[NLS_NUMERIC_CHARACTERS]=".,"

Plus , the advice here is good.

Answer 2

There is a good comment in the article , have you tried it?