Re: MSSQL text fields truncation

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:B.A.T.Svensson@lumc.nl] > Sent: 19 April 2001 17:48 > To: Dan Cleveland; php-windows@lists.php.net > 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: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >