Collating sequence "name" is not found (Error 1915)

  • Article

This error occurs when attempting to use a collating sequence that is not supported by the current code page. The collating sequence assigned with SET COLLATE command or the COLLATE clause in the CREATE TABLE - SQL, ALTER TABLE - SQL, or INDEX commands must be a valid Visual FoxPro collating sequence.

You must specify a compatible code page in your Visual FoxPro configuration file. For example, you might see the error, "Collating sequence "CZECH" is not found" when you issue the command:

SET COLLATE TO "CZECH"

To enable support for the CZECH collating sequence, add the following line of code to your Config.fpw file and restart Visual FoxPro:

CODEPAGE = 1250

For more information about collating sequences, see the SET COLLATE Command for valid collating sequences and Optimization of International Applications.