Hi everybody, I'm thinking about switching to innodb, but face the following problem: I've got a column with texts longer than 256 chars and I need an index on it (for having acceptable times for a query). So i can't use varchar and indexes are not possible in InnoDB in text/blob, so I can't use this either. Is there a solution, i.e. is there a data type for text longer 256 chars and with indexing in InnoDB ? Thanks for your answers Stefan -- Stefan Kuhn M. A. MPI of Chemical Ecology, Winzerlaer Str. 10, Beutenberg Campus, 07745 Jena, Germany Tel: +49(0)3641 571261 - Fax: +49(0)3641 571202
------------------------------------------------------- -- Stefan Kuhn M. A. MPI of Chemical Ecology, Winzerlaer Str. 10, Beutenberg Campus, 07745 Jena, Germany Tel: +49(0)3641 571261 - Fax: +49(0)3641 571202 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php