[thelist] From textarea field to SQL Server column

rudy r937 at interlog.com
Wed Feb 26 10:38:01 CST 2003


when the textarea gets cut off after a line break, it's likely your code

when it gets cut off after a 256, the target datatype is probably
varchar(256)

change this to varchar(nnnn) where nnnn < 8000

an html textarea can be 32k if i'm not mistaken, so if you need more than
8000, use text datatype, which can hold up to 2g

a text column when you don't really need one may involve needless overhead,
so use sparingly


rudy




More information about the thelist mailing list