Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Jimmy Shimizu
I believe you need to set Length, and it will use different types depending on the demand. In that case, you don't need to specify StringClob IIRC. Chris Sims wrote: I am using Castle ActiveRecord accessing an MS Sql 2005 DB. I need a Text field, but when I use the following code:

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Chris Sims
Is there a way to make the length unlimited for example : Length=Length.Unlimited ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Castle Project Users group. To post to this group, send email to

re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Terry Massey
Did you use Active Writer to generate this code. if So I have ran into the same issue before. and the resolution was to change it to string I belive I will have to check my code when I get home tonight late. -- I am using Castle ActiveRecord

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Tuna Toksoz
Not sure if it makes you happy but you can write the corresponding sql type manually/ Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, May 22, 2009 at 6:21 PM, Jimmy Shimizu

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Krzysztof Koźmic
I don't know about AR, but in bare NH you can set sql-type to varchar(max) (see here: http://kozmic.pl/archive/2009/05/19/storing-long-text-and-binary-blobs-with-nhibernate.aspx) Also you may set length=4001 to achieave the same effect. Krzysztof Chris Sims pisze: I am using Castle

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Jimmy Shimizu
Everything has an upper limit :) It's an integer, so use Int32.MaxValue if that makes you happy. Although I would restrict it to some sane value, depending on the target DB. Chris Sims wrote: Is there a way to make the length unlimited for example : Length=Length.Unlimited ?

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Chris Sims
Thank you everyone! Now I'm curious if the documentation at http://www.castleproject.org/activerecord/faq.html is incorrect? ColumnType=StringClob just doesn't seem to work as documented? On May 22, 10:26 am, Jimmy Shimizu jimmy.shim...@gmail.com wrote: Everything has an upper limit :) It's

Re: ColumnType=StringClob still creates varchar(255)

2009-05-22 Thread Bill Barry
StringClob should really map to NTEXT, not nvarchar(max) (although I am not sure what the difference is post sql 2005) Krzysztof Koźmic wrote: I don't know about AR, but in bare NH you can set sql-type to varchar(max) (see here: