Stefan, ----- Original Message ----- From: "Stefan Kuhn" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, December 16, 2002 2:11 PM Subject: Long text with index in InnoDB
> 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 ? the TODO list for InnoDB-4.0.x is December 2002: AWE support for Windows. January 2003: prefix indexes for TEXT and BLOB. Thus, the support is coming soon. > 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 Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query --------------------------------------------------------------------- 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