Insert data into a TEXT column.

[sushanth04]

I need to insert data in to a column of TEXT datatype through a sybase stored procedure.Since a variable of TEXT type cannot be declared inside a stored procedure ,I declared 2 varchar(255) and finally concatenated them and used it in the insert statement.

But I find the datas after 255th character gets truncated.

Is there any means of solving this issue ? I basically need to insert data into a column of TEXT datatype.

 

[gpadhy]

Here is a link which might help you:

http://dbforums.com/arch/160/2003/8/870707