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

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 开发者_C百科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.

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

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

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