INSERT large text amount gets truncated

Im trying to do a standard INSERT of over 8k of information into a mssql table via php. The funny thing is that mysql handled this perfectly and once i moved the system to mssql, i have had nothing but problems.

i know im not doing this right, im still very green when it comes to mssql, could someone please let me know how i can submit more then the alloted 8k to a mssql table without the info being chopped up after 8k.

thanks

8000 is the limit for varchar. if you want to exceed 8000, you'll have to use the "text" data type.