How can I use the :limit to change taggable_ type and context?

On Apr 24, 12:32 am, Frederick Cheung <[email protected]>
wrote:
> On Apr 23, 11:23 pm, Mike C <[email protected]> wrote:
>
> > I'm using the acts as taggable on plugin, and in the migrations
> > there's a line of code to create an index:
>
> > add_index :taggings, [:taggable_id, :taggable_type, :context], :name
> > => "tagging_index", :limit => {:name => 10, :surname => 20}
>
> > When I use unicode, the migration fails and I get told that the index
> > is too long and can only be 1000 bytes. I switched over to ascii to
> > see if I get the same problem and I didn't. I really want to use
> > unicode, so I want to get this working.
>
> If you want to limit the length of the prefix used for indexes, you'll
> need to change name/surname up there for the string columns you want
> to index (ie taggable_type and context) and change the numbers as
> appropriate to your data
>
> Fred
>
>
>
>
>
> > I'm running Rails 3.0.7 with MySQL 5.1.

-- 
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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to