I need clarification on the “Collation” settings for the manually created databases for tmsng and tmspe.
The TMS 14.3.2 install guide quotes a collation for tmsng of: Latin1_General_CI_AI
The TMSPE 1.1 deployment guide quotes a collation for tmspe of: Latin1_General_CI_AS
Why is tmsng AI (Accent Insensitive) and tmspe AS (Accent Sensitive), shouldn't they be both the same? In the UK we tend to remove accents in any case turning Ü into U but I'd like a definitive answer one way or the other.