|
Home > Archive > MS SQL Server ODBC > April 2005 > ODBC 4,099 byte record limit??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ODBC 4,099 byte record limit??
|
|
|
| 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");
}
| |
|
| Look for these values in php.ini
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
"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");
> }
>
>
>
>
|
|
|
|
|