>Naomi et al, many thanks for your helpful replies. It seems we were tripped up the recent VFP (7/8?) change to the way code pages are processed. By changing the PCs Windows regional language setting from Chinese to English, things now work. However, we sacrifice the Chinese characters stored in some fields. Mostly it is in English but some fields (in this database, common names for species and place names) are also stored in Chinese.
>
>So - to get things running on all 4 cylinders with Chinese and English characters, am I right to say we need to a) change the Windows setting back to Chinese b) change the code pages for all the DBF files in this project to the Chinese one and c) add a CODEPAGE= statement to config.fpw.... and a 'SET COLLATE TO ' if we want indexing correct too ... ? Many thanks, Denis
>
This sounds like it should work. In other words, you just need to make sure that databases code pages and SET COLLATE match everywhere for the whole application. I'm not 100% certain, but hopefully this would resolve your problem.
If it's not broken, fix it until it is.
My Blog