Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Croatian collating sequence for VFP9
Message
From
05/10/2006 09:19:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Croatian collating sequence for VFP9
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01159662
Message ID:
01159662
Views:
72
I'm not new in VFP and after same problems with VFP 6 I choosed VFP 9
with hope that sort and indexing tables with built-in national
sequences are better in this version. But..! Same thing. Code page is
1250 as I'm on WinXP under Windows for East Europe. All national
characters are properly visible on forms and in reports. But, when I
set some index on character field that contain national (diacritic)
characters they appear in wrong order (appear like last characters
even they shall be near top of list!). Collating sequence is MACHINE. I
tried with:

SET INDEX TO SYS(15,euroansi,lastname) TAG hrnames

but situation is a little bit better (e.g. one character is on 6th
place instead on 4th...but 5th character in our national order is
last!). I searched also on M$ MSDN pages but there is no clues about
it. Reports that are made by this way looks confusing and
unprofessional. I exported this table into TXT file and imported into
Excel and it sort proper all columns according national alphabet order
but VFP doesn't! :(
Is there some chance to make some "new" euroansi or european memory
variable with proper order of national (and other) characters or some
better solution is there?
Any idea? Thanks in advance.
Next
Reply
Map
View

Click here to load this message in the networking platform