Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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

Thank you. I'll give that a try

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc