CODEWITHSUNDEEP
sql-server-2008
shahnaz feiziamiri
shahnaz feiziamiri

Reputation: 23

change database collation without changing column collation

i change the collation of my database from

SQL_Latin1_General_CP1_CI_AS to 

Persian_100_CI_AI

but i don't want to change my Previous tables column collation and they have

SQL_Latin1_General_CP1_CI_AS collation now .

is it correct solution or it will Cause problems? thanks in advance

Upvotes: 2

Views: 1923

Answers (1)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239664

Changing the database collation doesn't affect any existing objects:

create database DB1
collate Latin1_General_CS_AS
go
use DB1
go
create table T1 (c varchar(20) not null)
go
alter database DB1 collate Latin1_General_CI_AI
go
select collation_name from sys.columns where name='c'

Result:

collation_name
---------------
Latin1_General_CS_AS

From Set or Change the database collation:

  • You can change the collation of any new objects that are created in a user database by using the COLLATE clause of the ALTER DATABASE statement. This statement does not change the collation of the columns in any existing user-defined tables. These can be changed by using the COLLATE clause of ALTER TABLE.

Upvotes: 2

Related Questions