General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Croatian collating sequence for VFP9
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only