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....