The SF/IAM databases are Case insensitve (Latin1_General_CI_AS) by default.
As we sometimes make some mistakes (who doesn't), we'd like to correct the cases in translations.
E.g. cange “Purchase order” to “Purchase Order”.
Currently there are 2 workarounds:
- update the records in transl table
- or, change to “Purchase Order1”, sync to all IAM's and change to correct “Purchase Order”
The idea we'd like to see implemented is that a collate Latin1_General_CS_AS compare takes place and also the update will take place in this collation so the correct cases will be stored.