>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.
Index on ... Collate "SLOVAK" - works for me. Not sure č and ć are properly distinguished, but they seem to be ordered right.
Note that since VFP8 (or maybe 7) you can't apply any collation sequence to any table - it now depends on table's codepage. Your tables need to have CP 1250 for this.