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]
