Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Croatian collating sequence for VFP9
Message
From
06/10/2006 09:17:22
 
 
To
05/10/2006 14:04:30
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01159662
Message ID:
01160000
Views:
16
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform