>I've also noticed that once you've keyed in Chinese characters into the tables, the PC's regional language needs to be fixed to Chinese. Otherwise you'll get "collation sequence PINYIN" is not found error message PLUS lots of C5 errors happening.
>Don't even think of compiling the exe while Chinese language is turned on. It altually corrupted some .prgs as the English characters used in the coding were converted to Chinese!
Yes, I have exchanged some messages with Rick on the weekend and the use of the VFP tables as a backend coming in from .NET using Ole Db is something that is practically impossible, in order to keep different languages in the same table. When I switched the backend to SQL Server, the problem went away.