>>Hi Jos.
>>
>>>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?
>>
>>Are you using a SET COLLATE TO 'PINYIN'? If so, wrap it in a TRY.
>>
>>Doug
>
>Hello Doug. I have no SET COLLATE statements anywhere in my application. When my application tries to open certain files this error pops up. All indexes in my files are set to machine collate. I do not make any explicit SET COLLATE statements.
Are you sure? And also no collate line in the config.fpw?
According to this
SET COLLATE this error appears when you try to set collation to non-existing collation.
If it's not broken, fix it until it is.
My Blog