Rails - Jun 2008 - switching from VARCHAR(255) to a blob

i have a comments thread setup but i initial set the datatype to
VARCHAR(255).

if i wanted to allow users to post more than 256 characters...what is
the best way to do this?

should i change the data type to a blob?  would this corrupt all current
data in the comments?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On Jun 27, 2008, at 6:10 PM, Scott Kulik wrote:
> i have a comments thread setup but i initial set the datatype to
> VARCHAR(255).
>
> if i wanted to allow users to post more than 256 characters...what is
> the best way to do this?
>
> should i change the data type to a blob?  would this corrupt all  
> current
> data in the comments?
Change to it to TEXT and optionally set a maximum size, otherwise the  
default is 64K I believe (for MySQL that is).

-- gw



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---