>Are any of your index keys longer than 120 characters? This could cause a problem in your environment.

Thanks for your kind attention, Fred. There is no such long indexes in the app. The longest index keys is 100 characters. And all of the indexes (about 150 .CDX) seems being changed to other collating sequence.

However, I have used DISPLAY STRUCTURE to examine the problem data, and found all indexes are MACHINE collation. But it simply pops up "Collating sequence "PINYIN" is not found" everytime I try to open it in English machines. I really can't figure out what's going wrong.