I know that I can change the collation of database object in localdb once they are created but, is there any option I can change that sets a default collation for the newly created objects? Or even better, is there anyway to say to the SQL Server process in charge of localdb instances to have a default collation different of SQL_Latin1_General_CP1_CI_AS?
I've searched for that, but I find nothing more than nasty procedures to change collation for already created databases... Is it possible that almost on year 2017 SQL Server doesn't offer this option?
From this link: SQL Server 2016 Express LocalDB
The instance collation for LocalDB is set to SQL_Latin1_General_CP1_CI_AS and cannot be changed. Database-level, column-level, and expression-level collations are supported normally.