Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Croatian collating sequence for VFP9
Message
De
06/10/2006 09:17:22
 
 
À
05/10/2006 14:04:30
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01159662
Message ID:
01160000
Vues:
17
Hi Mr. Nedeljkovich,
Thanks for your answer. I had set Collate to "SLOVAK" and created new table and populated with new data. After building index on field lastname (containing national characters) and issuing SET ORDER order in browse window is again confusing (CodePage od DB is 1250) beacuse lower case are between uppercase and also in no proper order. Then I tried this:

gcTranslationExpression =""
for i = 0 to 255
gcTranslationExpression=gcTranslationExpression+chr(i)
next i
gcTranslationExpression=chrtran(gcTranslationExpression,;
"ČĆĐŠŽZ","CCDSY")
save to gcTranslationExpression
RESTORE FROM curdir() + 'gcTranslationExpression' additive
and table is indexed by:
USE TEST3 EXCLUSIVE
INDEX on SYS(15,gcTranslationExpression,prezime) TAG baprez
REINDEX
SET ORDER TO tag baprez
BROWSE

but it order field prezime (only upper case is used) properly only if it contain only one letter; if you add full lastname they are loosing order. Realy weird. Very strange that in so mighty VFP9 has no easy solution for more than 25 mil. citizens :(
In any way, thanks you for your fast response.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform