[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