Re: Oracle PDO UTF-8 problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Doesn't work.

I got the following error after i set the parameter in the PDO construct

Fatal error: Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE'

IMHO this is only a MYSQL parameter but i worked with oracle.

Am 13.01.2011 10:27, schrieb kesavan trichy rengarajan:
Try increasing this: PDO::MYSQL_ATTR_MAX_BUFFER_SIZE

More info here:
On Thu, Jan 13, 2011 at 7:23 PM, Karsten Lehmann<lehmann@xxxxxxxxxx>  wrote:


I try to read a 2000 character long string out of database. The database is
an oracle 10g Express Edition with UTF-8 character set. To read the string
we use the PDO abstraction layer with oci-driver. If the 2000 character
contains one or more UTF-8 characters we get the problem that PDO truncate
the result of the database, with the following message:

Warning: PDOStatement::fetchAll() [pdostatement.fetchall]: column 5 data
was too large for buffer and was truncated to fit it in
C:\wamp\www\wp\bp.php on line 115

The definition of the database column is


CHAR means that we can store up to 2000 characters independent from the
encoding of the character (e.g. UTF8).

I also init the PDO with UTF8

$dbh = new PDO('oci:dbname=' . $db_name . ';charset=UTF8', $db_user,

If i read the same string with java and JDBC-driver it works fine, so i can
exclude a database error.

How i have to configre PHP/PDO to be aware of the truncation of the result

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux