For one new project we have a requirement to add multiple "Database Collation" support to the system, means the system will create DB on any specified DB Collations for Unicode, ANSI supported languages. This will not create the problem for new DB creation because in DB create script we can specify collation. As per DBA, we can achieve this by changing DB level collation and all Temp table creation query for existing DBs. Here my concern is, from a testing perspective, what sort of changes we need to test\verify like:
- What kind of test scenario we need to cover for this.
- What are the effects on the existing data stored in Table after these changes?
- How we can verify this data in testing?
- Any specific data set we require to create for this.