Subject Which character set/collation orders for English*4, French*2,German,Dutch, ...
Author Raymond Kennington
I want to avoid having a 2nd field for case-insensitve searches and also want
'dBase' to appear with 'DBASE' when ORDERed on the field.

The primary language will be Australian English, then Canadian English and
French, NZ English, UK English, French, German, Dutch and other West-European

Which character set should I use and which collation orders?

With these collation orders, if a field has a UNIQUE constraint on it, would
'dBase' and 'DBASE' be permitted or would they be treated as equal and the 2nd
attempt at entry cause an exception?

Raymond Kennington
Programming Solutions
W2W Team B