PHP retrieves truncated string data (thru SELECT with odbc_exec) - WHY ?

Amn

Hi all !

I perform a simple query looking like this "SELECT body FROM articles WHERE object_id = 2" (simplified version).
<body> is a large text type value, but upon retrieval, only a fraction (2/3rds) are displayed. I do not perform any truncation or manipulation of the string, only SQL select and then "echo" statement sends it to the document.

Are there any reasons PHP could behave like that ? The database is MIcrosoft Access, and using its internal SQL query writer, I can see that the data is not truncated.

May I be lacking memory in PHP or something ? THe script is very small, I cannot see that being a good reason...

Please help,

Thanks,

Amn.

tsinka

Hi,

there are some user contributed note in the PHP PHP manual that might solve your problem.

In short: The default length of data PHP reads is 4096. You need to either adjust php.ini or to modify the odbc function calls to change the length.

Thomas