"Repo" wrote:

> I'm connecting to an Access DB through ODBC on a windows server from a PHP
> page. The problem is the text retrieved from the select (nfo) is truncated
> at
> 4,099 bytes everytime.
>
> How to I get around this 4k limit?
> I read about SET TEXTSIZE but I don't know how to use it in the script?
>
> The full text is in the DB field so it is being truncated somewhere in the
> ODBC.
>
> PHP Script:
> ------------
>
> $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");
> }
>
>
>