Code: Select all
ALTER phpbb_posts_text CHANGE post_text post_text LONGTEXT
Myridden wrote: Hi,
I am having the same trouble with a board I am hosting for a friend, the problem is I am using MS SQL Server 2000.
The docs indicate that the text data type is capable of holding 2 gig, but the length is defaulting to 16 (65535) and I haven't been able to change it.
When someone posts more than the 64k, thier post is cut off and when you return the rows in SQL it shows <Long Text> in the posts_text field.
Anyone know how to change the length of the text data type?