MSSQL text fields truncation

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