>>After installing Visual FoxPro 6.0, the existing programme is giving me an error on the SQL - Select Statement for "Collating sequence Thai Not found" , I suppose it is due to Visual FoxPro 6.0 ODBC Driver Setup. because I checked the collating sequence setted for the indexes of tables, It's on "Machine".
>>
>>Can any one has face the same kind of problem ?
>>
>>Thanx and regards
>>Raj
>
>Raj,
>
>Define the CODEPAGE in your CONFIG.FPW and rerun VFP. In previous versions of VFP you could use any collating sequence, regardless of CpCurr() settings; now they have to correlate.
>
>(Gathered from several messages exchanged here in october between a Polish guy, George Tasker, Dragan and myself.)
Just an explanation of this correlation - one codepage covers for more collating sequences, e.g. 1250 covers for all of East European latin scripts, 1251 for all cyrillic, 1252 for all West European latin scripts (my knowledge ends here :).