this question is related to TDM 18.104.22.168 model update and settings/default values problem (SQL 2012).
I would like to set a default collation (which differs from the SQL Server's default collation) for all text columns. So I have opened Settings/Default Values and set Entities/Attributes/Collation to SQL_Latin1_General_CP1_CS_AS. But after running Model Update (I took the example from my thread mentioned above) all columns get a default collation - independent of the data type (see attached image #1).
Again I would not care if SQL generation knew that there's no collation for non-text data types. But unfortunately this is not the case (see attached image #2).
How do I have to set up a default collation for text columns which does not apply to non-text columns?
Thanks and best regards,