Sql Server Programming :: Collation Issue


	Collation Issue I've just come up against the issue of the tempdb's collation can end up being different dependent upon whether you SELECT INTO or CREATE TABLE. I was wondering whether there was a function I could call on certain columns of the SELECT INTO which would force the collation to be something other than the TempDB's default collation. My problem is that I'm using a DBLayer which doesn't easily expose the Collation properties of the underlying columns. Thanks Simon Simon Woods, Try using the "collate" clause. select c1 collate database_default as c1 into #t from dbo.t1 ... AMB - Hide quoted text - "Simon Woods" wrote: > I've just come up against the issue of the tempdb's collation can end up > being different dependent upon whether you SELECT INTO or CREATE TABLE. > I was wondering whether there was a function I could call on certain > columns of the SELECT INTO which would force the collation to be something > other than the TempDB's default collation. > My problem is that I'm using a DBLayer which doesn't easily expose the > Collation properties of the underlying columns. > Thanks > Simon Thank you. I'll give that a try - Hide quoted text - Alejandro Mesa wrote: > Simon Woods, > Try using the "collate" clause. > select c1 collate database_default as c1 > into #t > from dbo.t1 > ... > AMB > "Simon Woods" wrote: >> I've just come up against the issue of the tempdb's collation can >> end up being different dependent upon whether you SELECT INTO or >> CREATE TABLE. >> I was wondering whether there was a function I could call on certain >> columns of the SELECT INTO which would force the collation to be >> something other than the TempDB's default collation. >> My problem is that I'm using a DBLayer which doesn't easily expose >> the Collation properties of the underlying columns. >> Thanks >> Simon