'How to change collation on SQL Server by SSMS

The purpose is that I want to change collation (database, table, column) from Chinese_Taiwan_Stroke_CS_AS to SQL_Latin1_General_CP1_CI_AS.

There is the way that I change the collation on database.

First, I use the old_db tasks --> General scripts... and set the script collation false with schema only.

Then, I renew the scripts database name to new_db and set the collation = SQL_Latin1_General_CP1_CI_AS.

There is no error to here.

Finally, I want to import the data from old_db to the new_db by export data from old_db to destination new_db, but it will show the error 0xc02020f4.

I think that this error is related to collation issue, but I want to change collation so the old_db and new_db must be different. How can I solve it?

By the way I have viewed other topics about change collation but it's still not work for me due to the error:

Incorrect syntax near the keyword 'CONVERT'

so I try another way to do.

sql-servercollationsql-server-collation


Solution 1:[1]

Changing the collation at any level has no effect on actual data stored. You need to move externally or internally the data from a column to another or a table to another or all the table of the database to another database after allways having precisely specified the correct collation in the ALTER or CREATE statement

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 SQLpro

Related Questions