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

Hi Dragan and Doug,

I found the NLS files on my computer and can find the PINYIN one. What to do with it though? Just throw it in the system32 folder on the user's machine and that's it?

Also, do you think CREATE TABLE could be the problem i.e. when I issue it without explicitly specifying the code page that it defaults to PINYIN and that's the problem?