'Collating Sequence' error message 1

[jrajesh]

Hi Fox-gurus,
We have a VFP 7 application where it is mandatory that all input be in English.
On one of our sites, the user has a Chinese input tool (Richwin) installed on the PC and is getting an error message Collating sequence 'PINYIN'is not found'.

Please advise whethere there is any setting that can be done in the VFP app. to fix this error.

Thanks and best regards,
Rajesh

 

[Mike Gagnon]

jrajesh

Have you tried SET COLLATE TO GENERAL?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[MirekZvolsky]

In CONFIG.FPW file you probably have CODEPAGE=AUTO or AUTO is a default (if CODEPAGE= isn't in CONFIG.FPW or you have no CONFIG.FPW at all).
Add or modify the line in CONFIG.FPW to CODEPAGE=1252 (Windows ANSI). Then standard collating sequence will be used.
CONFIG.FPW you can make Included in your project (build into your EXE), or Excluded and let it as file in same folder, where your EXE is placed.

Or inside program you can change the collating sequence with SET COLLATE command (for current CodePage some collating sequences can be accessible only).

 

[jrajesh]

Many thanks Mike and MirekZvolsky.
I'll try what you've suggested and revert with the result.

Thanks again and warm regards,
Rajesh

 

[jrajesh]

Mike and MirekZvolsky:
Thank you very much for your solutions.
They worked perfectly well.
Thanks again and *s to you both.
Warm Regards,
Rajesh