CODEWITHSUNDEEP
sql-serverlocaldb
Vi100
Vi100

Reputation: 4203

How to change DEFAULT collation of localdb?

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?

Upvotes: 0

Views: 3380

Answers (2)

Sameh Maher
Sameh Maher

Reputation: 1

you can

Open SSMS -> Connect Server name: (LocalDb)\MSSQLLocalDB, Choose Windows Authentication.

if you cannot shown your database you can attach it from your bath

then from properties and click option tab then change collation to Arabicenter image description here

it`s successfully with me

Upvotes: 0

TheGameiswar
TheGameiswar

Reputation: 28930

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.

Upvotes: 5

Related Questions