Collation Issue

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  September 7, 2010 at 1:33 am

  #225695

  Hi,

  I just want to know, if i change the collation in a database or column level in sql objects?

  what will happened? is there any other performance issue will come?

  I have one table called Emplyee. It consists of 7 columns. first 4 column are Latin_General type

  Collation. The Other Columns are in SQL_Latin_General type collation.

  If i change the collation from SQL_Latin_collation to Latin_General type collation.. is there any problem occurred? I would really appreciate, if anybody helps me out this issue

  Thanks & Regards

  Balaji.G

• ss-457805

  SSCertifiable

  Points: 5872

  More actions

  September 7, 2010 at 3:17 am

  #1217197

  you can find information here:

  http://msdn.microsoft.com/en-us/library/ms190920.aspx

  http://msdn.microsoft.com/en-us/library/ms175835.aspx

  blog: http://sarveshsingh.comTwitter: @sarveshsing

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  September 7, 2010 at 3:55 am

  #1217208

  in that case, then every time in your query you need to define itin your matching condition. Something like :-

  select.....

  from tabl1 a inner join table2 b

  ON a.columnname= b.columnname COLLATE Latin1_General_CI_AS

  where .................

  ----------
  Ashish