>>>>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.

Do these files need to be registered with Windows or simply copied to the System32 folder and left there? Does VFP need to do anything, any settings in the application like issuing a SET COLLATE instruction or anything like that? Can I just email the NLS file to the end-user and tell him to save the file to Windows\System32?