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

Reply via email to