Hi Pavel,
>I read some threads about set collate and now I'm scared (and sweating).
>I use ONLY set collate to "czech" !
Sorry, it wasn't my intention to scare you... I can't say anything about "czech", since my VFP only says that it can't find this collate sequence.
>Maybe - I haven't problems with speed - because I have little tables (up to 500k rows) ? or 90% of indexes are on integer fields ? or ...
IMO, speed is not really the main issue. In most cases "General" (that's all I can talk about) is only 80% slower than "machine". The real problem is that this collate sequence might return wrong result sets. "General" does and you should carefully check whether "czech" does or does not.
>So, rewrite applications or not (many "order by") and can I mix machine indexes with czech collate for order by and (horror) can my applications now lies ?
If it returns wrong result sets, yes, you should rewrite your application as quickly as possible. You can mix indexes with different collate sequences as long as you NEVER use these "wrong" indexes to search data and never activate this collate sequence besides for indexing. But there's no problem when you index a view using the "czech" collate sequence for displaying purposes only.
Christof
--
Christof