Thank you Clive and Jeremy, Problem resolved, after indexing username field and adding 256 key size. I used the execute sql statement of Jeremy, but i'm also sure that Jeremy tip would do the same.
Thank you so much. Vag. On Feb 28, 2:38 pm, Clive Crous <[email protected]> wrote: > Just an addendum to this, I don't think there's any way to do this at the > moment in Sequel using it's own methods, your best bet is probably to insert > it in your code like this: > > If I'm incorrect about Sequel's lack of support for this I'm sure someone > will shout be down ;) > > unless DB2[:mytable].table_exists? > DB2.create_table :mytable do > column :username, :text > ... > .. > end > DB2.execute("ALTER TABLE mytable ADD INDEX mytable_username_index > (username(256));") > end > > Clive > > 2009/2/28 Clive Crous <[email protected]> > > > => ALTER TABLE mytable ADD INDEX mytable_username_index (username(256)); > > > You have to give a key size ( the 256 above ) to columns of TEXT and BLOB > > type in MySQL. > > > Clive > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-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/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
