Hi,

> > The maximum size for an index key is 253 bytes. This maximum gets
> > progressively reduced as you "load up" the attributes of the key:
> multiple
> > columns, multi-byte character sets and, in your case, a character
> set that
> > "eats" a lot of extra bytes AND a collation sequence that eats even
> more.
>
> This is *extremely* disappointing to hear. I mean, wow! words fail me!
> Does this mean I cannot efficiently sort fields > 84characters in
> size?

Indices are sometimes used for sorting, but that's just
a side-effect.

In general, indices are used for fast lookups, not for sorting.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com