How to chnage Collation for EVERYTHING in a database

Will Gilbert

Member
Joined
Dec 1, 2020
Messages
6
Programming Experience
5-10
Just restored a database from another site and running into all sorts of problems to do with Collation
Is there any 'easy' way to just completely change Everything in a database to a specific collation
e.g. Tables, Columns, Indexes, Constraints,. in other words everything
Something like: Change Database MyDatabase to Collation Latin1_General_CI_AS

(I cannot find ant 'simple way to do this)
 

Skydiver

Staff member
Joined
Apr 6, 2019
Messages
3,555
Location
Chesapeake, VA
Programming Experience
10+
I don't understand why this is C# question. Sounds more like a SQL question.
 

jmcilhinney

C# Forum Moderator
Staff member
Joined
Apr 23, 2011
Messages
4,060
Location
Sydney, Australia
Programming Experience
10+
I just searched the web for "sql server change collection for database" and this was the first result. Am I missing something or did you not bother searching for yourself before posting? If you did find that page and did what it instructs then what's the actual problem? If we don't know what you did and what happened then we can't know what you did wrong.
 
Top Bottom