RE: ODBC 4,099 byte record limit??
- From: "LD" <LD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 15 Apr 2005 13:35:02 -0700
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");
> }
>
>
>
>
.
- References:
- ODBC 4,099 byte record limit??
- From: Repo
- ODBC 4,099 byte record limit??
- Prev by Date: ODBC connection
- Next by Date: Does UPDATE BLOB Destroy the Cursor in SQL Server 2000?
- Previous by thread: ODBC 4,099 byte record limit??
- Next by thread: Batch Insert With SQL_ATTR_PARAMSET_SIZE Slow
- Index(es):
Relevant Pages
|
Loading
