How to set collation to the table?

• chinni2383

  Valued Member

  Points: 62

  More actions

  October 8, 2008 at 2:59 pm

  #96752

  Hi,

  I need to set a collation of one table to another.

  I'm using following code.

  declare @collation1 int

  Set @collation1 = (select collation from sysobjects so

  inner join syscolumns sc

  on so.id = sc.id and sc.name = 'uiName'

  where so.name like 'Dictionary')

  if ( exists ( select * from sysobjects where name = '#a' ) )

  drop table #a

  GO

  CREATE TABLE #a(ObjectIdHi int, ObjectIdLo int, OwnerIdHi int, OwnerIdLo int, OwnerPath varchar(200) COLLATE collation1, uiName varchar(200) COLLATE @collation1) select d.ObjectIdHi, d.ObjectIdLo, d.OwnerIdHi, d.OwnerIdLo, d.OwnerPath, d.uiName

  from #ObjList d

  But in at CREATE TABLE statement I'm getting the below error

  Invalid collation 'collation1'.

  How to resolve this error?

  Please help me.

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  October 9, 2008 at 8:09 am

  #882907

  [font="Verdana"]Its not possible to set collation at run time. Mention the exact collation.[/font]

  MH-09-AM-8694