>>>Hi All,
>>>
>>>I have a user in Singapore who is getting an error when running our application as follows:
>>>
>>>"Collating sequence PINYIN is not found".
>>>
>>>I have checked the help file and PINYIN is simplified Chinese collate sequence. My question is, how best to handle a resolution to this problem? Our users are mainly American and European based - what is the recommended way to resolve this?
>>
>>Install the appropriate .nls files on that workstation, I'd guess. Collating sequences used to be inside the foxpro.int file, but since, I guess, VFP7 or 8, that file is deprecated and Fox uses collating sequences found in the Windows system.
>
>Where are these NLS files? And how do you tell the application where to find them / load them ?
%system%\system32. Their names are, of course, cryptic - c_nnnnnn.nls, where nnnnn is, I guess, the codepage number. They are registered in Windows, so the app doesn't really need to know anything, it calls a system service which returns the collating table. You just had a table missing. I think it's added from the regional settings, support for this or that language.