Is it possible to have a varchar(max) column for an ActiveRecord object type?

Question

I really want to have a column of inifinite length for one of the properties of my ActiveRecord object of type string, but I don't know how to set it. When I set the length to -1 (the number for MAX in SQL server) I get an error.

Can anyone help?

EDIT: I meant to say Castle ActiveRecord.

Answer 1

set the data type of the column to text....

Answer 2

the varchar(max) or nvarchar(max) type is suitable for you.

Answer 3

I found the answer. Apparently if you set the length to anything greater than 4000 it will set the column to MAX length.