SQL Server 2008: String or binary data would be truncated

[Keith]

Hello again.

I'm about to pull my whole hair with this one...
My database has a table Articles (news). So, one of the fields is obviously the text from that article. I defined it as TEXT data type.

This error: "String or binary data would be truncated." appears every time I try to add text to that field on a existing record.

And somehow this is causing me one other problem. Everytime I try to get this text on a PHP page, the text was cut (more than half of it).

I've been doing some reading, and the Text field supports up to 2.000.000 characters. I don't intend to use more than 12.000 per record. But it seems that no other data type can support as many as Text.


Am I doing something wrong?
Please help me,

Thanks

[Keith]

Solved my problem.
It's not MSSQL related, but PHP.
By default, the maximum data PHP can get is 4096 (2^12) characters.

What you need to do: edit the php.ini file.

mssql.textlimit = 1048576

mssql.textsize = 1048576

1048576 = 2^20, so that should be enough for. If not, increase the values above.