Try increasing this: PDO::MYSQL_ATTR_MAX_BUFFER_SIZE

More info here: http://php.net/manual/en/ref.pdo-mysql.php
On Thu, Jan 13, 2011 at 7:23 PM, Karsten Lehmann <lehm...@maqsima.de> wrote:

> Hello
>
> 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
>
> TESTSTRING VARCHAR2(2000 CHAR)
>
> 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,
> $db_pw);
>
>
> 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
> string?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Reply via email to