SQL Collation issue in temp table.

iteye_17686

于 2012-05-28 13:38:00 发布

阅读量77

点赞数

本文介绍了一种在创建临时表并将其与现有表联接时遇到的SQL Collation冲突问题。这种冲突通常发生在服务器默认Collation与表Collation不一致的情况下。文章提供了一个简单的方法来避免这一错误：通过明确指定临时表的Collation。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

When you create a new temp table and join it with existing tables. you may got this error "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.",

This because the default collation in Server defferent from the collation in the tables.

To avoid this error, you can simply change the definition for the temp table as follows,

CREATE TABLE #tmp(NcesSchoolId NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS
				, MSRRank INT
				, SchoolNum INT)