Re: ColumnType=StringClob still creates varchar(255)
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:
[Property(ColumnType=StringClob, Column =
products_description)]
public String Description { get; set; }
The column ends up being created as a varchar(255). What am I doing
wrong and how do I resolve this issue?
Thank you!
Chris Sims
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Castle Project Users group.
To post to this group, send email to castle-project-users@googlegroups.com
To unsubscribe from this group, send email to
castle-project-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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 castle-project-users@googlegroups.com To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~--~~~~--~~--~--~---
re: ColumnType=StringClob still creates varchar(255)
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 accessing an MS Sql 2005 DB. I need a
Text field, but when I use the following code:
[Property(ColumnType=StringClob, Column =
products_description)]
public String Description { get; set; }
The column ends up being created as a varchar(255). What am I doing
wrong and how do I resolve this issue?
Thank you!
Chris Sims
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Castle Project Users group.
To post to this group, send email to castle-project-users@googlegroups.com
To unsubscribe from this group, send email to
castle-project-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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 jimmy.shim...@gmail.comwrote:
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:
[Property(ColumnType=StringClob, Column =
products_description)]
public String Description { get; set; }
The column ends up being created as a varchar(255). What am I doing
wrong and how do I resolve this issue?
Thank you!
Chris Sims
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Castle Project Users group.
To post to this group, send email to castle-project-users@googlegroups.com
To unsubscribe from this group, send email to
castle-project-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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 ActiveRecord accessing an MS Sql 2005 DB. I need a
Text field, but when I use the following code:
[Property(ColumnType=StringClob, Column =
products_description)]
public String Description { get; set; }
The column ends up being created as a varchar(255). What am I doing
wrong and how do I resolve this issue?
Thank you!
Chris Sims
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Castle Project Users group.
To post to this group, send email to castle-project-users@googlegroups.com
To unsubscribe from this group, send email to
castle-project-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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 ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Castle Project Users group. To post to this group, send email to castle-project-users@googlegroups.com To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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 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 ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Castle Project Users group. To post to this group, send email to castle-project-users@googlegroups.com To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~--~~~~--~~--~--~---
Re: ColumnType=StringClob still creates varchar(255)
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:
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 ActiveRecord accessing an MS Sql 2005 DB. I need a
Text field, but when I use the following code:
[Property(ColumnType=StringClob, Column =
products_description)]
public String Description { get; set; }
The column ends up being created as a varchar(255). What am I doing
wrong and how do I resolve this issue?
Thank you!
Chris Sims
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Castle Project Users group.
To post to this group, send email to castle-project-users@googlegroups.com
To unsubscribe from this group, send email to
castle-project-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~--~~~~--~~--~--~---
