PHP 4.0 Bug #7437 Updated: Long memo fields are truncated

ID: 7437 User Update by: norbertoh@hotmail.com Status: Feedback Bug Type: ODBC related Description: Long memo fields are truncated phpinfo() reports: Directive: odbc.defaultlrl Local Value: return up to 4096 bytes Master Value: return up to 4096 bytes Setting odbc_longreadlen() solves the problem but, why the PHP.INI has no effect? Previous Comments: --------------------------------------------------------------------------- [2000-10-26 04:06:10] kara@php.net What does phpinfo() report about the value of defaultlrl? Does truncation also happen when setting the length with odbc_longreadlen() manually? --------------------------------------------------------------------------- [2000-10-24 15:22:15] norbertoh@hotmail.com The php file has the following structure: <? $conn = odbc_connect("tar_CHT", "", ""); $mapas = odbc_do($conn,"SELECT * FROM País_Mapas WHERE CStr([ID_País])=1 "); ?> ... <? echo odbc_result($mapas,"Codigo_HTML") ?> Where "tar_CHT" is a system DSN of an Access database, "Pais_Mapas" is a table and "Codigo_HTML" is a memo field. This field sometimes have more than 4K characters. Working with PHP3: In PHP3.INI, if i leave the uodbc.defaultlrl parameter in 4096, sometimes the "Codigo_HTML" field is truncated. I solve the problem changing that value to, for example, 8192. Working with PHP4: In PHP.INI, if i change the uodbc.defaultlrl parameter to 8192, the field is still truncated. Both PHP3.INI and PHP.INI are in the "Winnt" directory. Other parameters in the .INI files remain with the default values. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7437