Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collating Sequence not Found error
Message
From
28/06/2007 20:59:35
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
 
 
To
27/06/2007 14:04:53
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01236057
Message ID:
01236654
Views:
12
actually we can't open the table if chinese-star program haven run yet
so we can't kill the cdx and recreate it unless the chinese-star program is running first.....
after killing and recreating the cdx, the same thing happen if we forgot to run the chinese-star program again !
another thing is all the MS Office application can key in chinese charactor whith language CH come with XP but VFP cannot ! Why ????


Kill the cdx and recreate it. It may have been created in an earlier version of Fox (from 2.6 up to VFP 7, I think), where you could index any table on any collating sequence, regardless of the table's codepage. Since VFP8 there's a limitation, the codepage limits the choice of allowed collate sequences - you can't index a cyrillic table on Korean sequence etc.

It's also possible that the app where the data entry was done didn't enforce a codepage, so it assumed codepage=auto, accepted the Chinese codepage and created this table - the solution in that case is just to install support for Pinyin on your client's mahine, so the appropriate .nls table would be available. VFP should then be able to open the table.

A workaround may be to open the table in an earlier version of Fox, and then there append from it into a new table.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform