[thelist] From textarea field to SQL Server column
Joshua Olson
joshua at waetech.com
Wed Feb 26 10:50:01 CST 2003
----- Original Message -----
From: "rudy" <r937 at interlog.com>
Sent: Wednesday, February 26, 2003 11:38 AM
> when the textarea gets cut off after a line break, it's likely your code
+1
> when it gets cut off after a 256, the target datatype is probably
> varchar(256)
+1
> 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
This depends on the browser used. On IE 6.0 PC I have been able to submit
up to 64k in data. One Mac I saw limited the post to 32k. I _believe_ this
is because the Mac submitted in Unicode and therefore could only submit half
the number of characters.
-joshua
More information about the thelist
mailing list