>I have a problem as fallows: I am working on an FOX 2.6 international application that should work with English and Hungaian letters. I would like to make an order on a field that has english and hungarian data. Hungarian letters are same in 28 letters as english but has some extra letters those are between English letters in alphabet list but their codes in hungarian codepage are not in their correct places. I should insert them between english letters in my index. Think of it as I should make an order based on a new alphabet list in english (for example) that one new symbol should be inserted between "A" and "B". Notice that the code of "A" is 65 and "B" is 66 and I want my order sort the field in ascending mode in a case that "A" is before my symbol (That its code is 196 for example) and "B" is after it.
Semmi baj. Set Collate "Hungary" and create your indexes.
>(Fox 2.6 doesn't have hungarian collating sequence.)
It has. I was using it. But your tables have to be marked with a codepage 1250 (for FPW2.6) or 852 (for FPD2.6). Then you can have your collating sequence.
To mark a table with a collating sequence, use cpzero.prg - like
do home()+"tools\cpzero\cpzero" with "< táblázat neve ide >", 1250
Under FPD2.6 it was possible to create collating sequence independently from the codepage of the table, but that may lead to problems, and wouldn't reindex anymore under VFP7 (not sure of 6), because this is checked now.