Subject Re: error: key size too big for index
Author Aage Johansen
vsvadlenka wrote:
I need collation on columns, because I access database through ODBC
driver and without collating sorting is bad.

Indexes are great for selecting records, but for sorting the benefit might
prove 'negative'. If you want to have an index just for sorting you may be
better off without that index.
If the sorting is "bad" you can try to specify the collation directly in
the 'order by' clause.

There is a limit on key length, and it depends on the (number of bytes per
character in the) character set (I think).

Aage J.