RE: [PHP-WIN] SQL Server - 255 field size limit in PHP ?
| From: | HKG) | Date: | Tue, 01 Jul 2003 11:12:44 +0000 |
| Subject: | RE: [PHP-WIN] SQL Server - 255 field size limit in PHP ? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-20637@lists.php.net to get a copy of this message | ||
For instance as default the ODBC driver is set to return maximum
255 chars in column. Change your setting to reflect your needs.
> -----Original Message-----
> From: DessieD [mailto:des_doyle@yahoo.com]
> Sent: Tuesday, July 01, 2003 11:55 AM
> To: php-windows@lists.php.net
> Subject: [PHP-WIN] SQL Server - 255 field size limit in PHP ?
>
>
> Hi
>
> Im new to PHP so may be an obvious workaround to this. Not sure if it could
> be a bug in PHP..
>
> I have a SQLServer table that contains a large nvarchar field (size: 2000).
> My php code to retireve and display this field is something like (dont have
> code to hand right now):
>
> $quote = mssql_fetch_array($query);
> echo $quote[0];
>
> The problem is that only the first 255 characters are getting returned by
> PHP !? The mssql_fetch_array function creates the returned array so its not
> something I can manually size etc.
>
> Anyone seen this before, or offer any comments ??
>
> Thanks
>
> D
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>