Re: Re: PHP and SQL Server
| From: | Andrew Ballard | Date: | Tue, 23 Sep 2008 14:52:04 +0000 |
| Subject: | Re: Re: PHP and SQL Server | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-280774@lists.php.net to get a copy of this message | ||
On Tue, Sep 23, 2008 at 10:43 AM, Nathan Rixham <nrixham@gmail.com> wrote:
> Andrew Ballard wrote:
> [snip]
>>
>> 4K limit on TEXTSIZE
>
> [/snip]
>
> As far as I was aware this was a PHP thing that can be changed in your
> php.ini [mssql.textlimit and mssql.textsize]
>
We have, and it affects the regular MSSQL functions, but not
PDO_MSSQL. What's more, I just discovered that with PDO_MSSQL, not
only are TEXT/NTEXT fields truncated to 4K, VARCHAR/NVARCHAR fields
are apparently truncated to 255 characters.
Andrew