I am connecting to MS Access DB with ODBC on Windows Value server from a PHP page.
When I select the text from a DB memo field (nfo), the text is always truncated at 4099 bytes.
I checked the Acess DB and the full text is in the field so it is being limited at 4k in the ODBC.
How do I get around this limit? I think maybe it set at the server level (textsize)? Or odbc.defaultlrl in php.ini ?
PHP code:
----------
$connect = odbc_connect("datab_nfo", "", "");
$query = "SELECT nfo FROM Titles where ID=15";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$nfo = odbc_result($result, 1);
print("$nfo\n");
}
EDIT: Sorry please disregard, I finally fixed this with odbc_longreadlen.
When I select the text from a DB memo field (nfo), the text is always truncated at 4099 bytes.
I checked the Acess DB and the full text is in the field so it is being limited at 4k in the ODBC.
How do I get around this limit? I think maybe it set at the server level (textsize)? Or odbc.defaultlrl in php.ini ?
PHP code:
----------
$connect = odbc_connect("datab_nfo", "", "");
$query = "SELECT nfo FROM Titles where ID=15";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result)){
$nfo = odbc_result($result, 1);
print("$nfo\n");
}
EDIT: Sorry please disregard, I finally fixed this with odbc_longreadlen.