Is it possible to specify a collation for 1 specific column in a table in the model?
The default database collation is set to SQL_Latin1_General_CP1_CI_AS
Currently we have this special column that really wants be case-sensitive and wants to be unique. The latter can be achieved, but we cannot seem to find a way to make this specific column case sensitive towards the database.
I also would like to have the user interface to react to it as it was case insensitive in lookups for example. How can I achieve such functionality? An example is milliohm [mΩ] to meg(a)ohm [МΩ] (or mOhm and MOhm) - the column for such unit has to be unique since they actually really mean a load of difference in resistance, but I want them to be found by the user when typing in any case ‘mohm’.
Best answer by Ricky
Just made an idea out of it.