You can set the limits in php.ini using these settings:
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
- Frank
> Hi,
> I've got a new problem to do with how long things can be! This time it is
> from a text field so I would expect there to be no limit. But my text is
> being cut off after 4096 characters. I am selecting with a mssql_query and
> then using mssql_fetch_array to get the results. Has anyone run into this
> problem before,
> Thanks,
> Kelvin.
>
> -----Original Message-----
> From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
> Sent: 19 April 2001 17:48
> To: Dan Cleveland; [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] Re: MSSQL varchar fields truncation revisited
>
>
> >i was under the impression that varchar fields in mysql had a
> >limit of 255 characters.
>
> I believe they were talking about the M$ SQL server? In version 6.5 the
> varchar were limited to 255 bytes, but with version 7.0 the length can be
> extended to 8000 bytes... and also Stored Procedures can now be, hmm, 128MB
> in size.
> This change happened due to developers complaints of the former limit of
> 64kb in version 6.5 - I guess they put the limit to 128MB just to keep the
> mouth shout for ever within the community of database developers. ;)
>
> I base this on what I heard at a conference I did attend some years ago in
> Gothenburg/Sweden. At that time Microsoft had a presentation of "The Sphinx"
> (== SQL Server 7.0 beta) they actually stressed the storing capacity of 128
> MB, and said "We believe this will be enough for you..." (WHO did once
> proclaimed that 1MB will be enough for a computer system... :)
>
> About the 64kb sp memeory limitation in version 6.5. Microsoft claims a sp
> can be as big as 64kb in version 6.5, but actually they can only be about
> 54kb - I knew this because I used to run into this limit quite often - and
> wouldn't really had minded that few extra kb's. ;) Fortunately I haven't
> explored the limitation of 128MB in MS SQL Server 7.0 - at least not yet...
> :)
>
> Regards,
>
> /Anders
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
