Re: [PHP-DB] Oracle PDO UTF-8 problem

2011-01-14 Thread Christopher Jones
Glad you resolved it. Overall, I have to recommend the OCI8 extension over the unmaintained (like much of PDO) PDO_OCI extension. Chris On 01/13/2011 11:36 PM, Karsten Lehmann wrote: I found out that the error depends on the wrong character set of the Oracle Database. In my case this was a

[PHP-DB] Oracle PDO UTF-8 problem

2011-01-13 Thread Karsten Lehmann
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

Re: [PHP-DB] Oracle PDO UTF-8 problem

2011-01-13 Thread kesavan trichy rengarajan
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

Re: [PHP-DB] Oracle PDO UTF-8 problem

2011-01-13 Thread Karsten Lehmann
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:

Re: [PHP-DB] Oracle PDO UTF-8 problem

2011-01-13 Thread Karsten Lehmann
I found out that the error depends on the wrong character set of the Oracle Database. In my case this was a Western Europ instance of the Database. The same data on a UTF8 instance was displayed as excpected. Am 13.01.2011 10:42, schrieb Karsten Lehmann: Doesn't work. I got the following