As it is stated to use more than 256 characters you need to use text
columns. If your text is let's say around 256 but bigger than this you may
consider using two varchar columns instead of one.
Quote:>Im using the Web as a front end form to an SQL database. I've added a
><TEXTAREA TYPE="TEXT" NAME="Comments" ROWS="2" COLS="60">
>The text area works fine until it exceeds 256 characters. This is the
>error I receive:
>ODBC Error Code = 22005 (Error in assignment)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from
>datatype 'text' to
> 'varchar' is not allowed. Use the CONVERT function to run this query.
>I need the ability to exceed 256 characters in SQL. Does anybody know
>of a work around?
>Thanks in advance