Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collating sequence
Message
From
12/04/2002 07:42:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
12/04/2002 07:33:11
Balazs Simon
Unit Informatics Ltd.
Budapest, Hungary
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00644153
Message ID:
00644157
Views:
10
>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.
>(Fox 2.6 doesn't have hungarian collating sequence.)
>
>Thanks for any idea.

I believe that if VFP doesn't support this specific collation sequence, and the "general" is not satisfactory for you, you have to create your own UDF() to do the sorting. Or perhaps, just create your table of characters (in memory variables), and use ChrTran() to translate the characters.

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform