>I create a table
>
>CREATE TABLE TEST (TEST C(121)) (or more)
>SET COLLATE TO 'GERMAN'
>INDEX ON TEST TAG TEST Invalid Key Length
>
>But
>SET COLLATE TO 'MACHINE'
>INDEX ON TEST TAG TEST (ok)
>
>Works fine....
VFP keys can only be 240 bytes long. When you use a collate sequence of anything but MACHINE, VFP uses 2 bytes per character in the key, so the maximum size of the key is really only 120 bytes.
Doug