>I recently changed the collate setting to GENERAL to display a more logical order with the french characters. Since I did that, I can't create an index on a 170 character field anymore. It was working fine with the collate MACHINE before. Any workaround to keep my Collate GENERAL setting?
>
>TIA
Salut Mario,
According help, "The length of an index key for a .CDX index must be between 1 and 240 characters." But what it does not say is that the General collating sequence has to cope with hi ASCII characters and is therefore limited to 120 characters.
Try this:
SET COLLATE TO "GENERAL"
INDEX ON SUBSTR(cText, 1, 120) TAG Text && no problem
INDEX ON SUBSTR(cText, 1, 121) TAG Text && invalid key length problem.
So you've hit one limit of the system.
That said, I don't find it very effective to have fields indexed on such large lengths.
José