International Support (Visual FoxPro ODBC Driver)

  • Article

The Microsoft Visual FoxPro ODBC Driver supports:

  • Double-byte character sets (DBCS)

  • Multiple collating sequences

A collating sequence defines the sort order for data stored in a Visual FoxPro table or database. By default, the driver is configured to use the collating sequences that support the language version of your operating system.

For a list of supported collating sequences, see SET COLLATE.

locale

The set of information that corresponds to a given language and country/region. A locale indicates specific settings such as decimal separators, date and time formats, and character-sorting order.

sort order

Sort orders incorporate the sorting rules of different locales, allowing you to sort data in those languages correctly. In Visual FoxPro, the current sort order determines the results of character expression comparisons and the order in which the records appear in indexed or sorted tables.