Solved

Need to change SQL collation

Posted on 2011-09-07
3
233 Views
Last Modified: 2012-08-13
hi a developer has come to site and created a database with the wrong collation
they have created collation : sql_latin1_general_CP1_CI_AS

instead of
Latin1_General_CI_AS

can I get the command sequence to force this change.
0
Comment
Question by:Amanda Walshaw
3 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 200 total points
ID: 36501002
0
 
LVL 9

Assisted Solution

by:mimran18
mimran18 earned 200 total points
ID: 36501070
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 100 total points
ID: 36505798
Carefull that changing database collation does not changes ALL existing columns collation by default but just new objects/columns from that moment on will have the new collation. You will have to write dynamic or static code depending how many "text" type columns you have to alter table alter column with new collate.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Write a function 5 26
SQL 2012 and SQL 2014 always on 9 25
Log Backup 2 13
Usage Scenarios for Extended Events? 1 12
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now