I always use Latin (never French) and I prefer to use SQL_Latin1_general_cp1_CI_AI

CI = Case insensitive
AI = Accent insensitive

This means that e and é and è will all be considered as e when sorting.


>When we select collation name, we use SQL_Latin1_general_cp1_c1_as.
>
>I also found there are some collations like French_?.
>
>Which one should we select? What is different of them?
>
>
>Thanks
>
>
>Jim