mysql - 在同一个 SQL.Server 上跨 2 个数据库加入时的 COLLATE 问题

Question

我一直收到这个错误:

Cannot resolve the collation conflict between "Latin1_General_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

我不确定如何修复它。

我通过连接两个数据库中具有不同名称的列来连接同一服务器上的两个不同数据库。

SELECT t1.ColumnNameDB1, t2.ColumnNameDB2
FROM DB1.schema.TableName AS t1
INNER JOIN DB2.schema.TableName as t2
ON t1.ColumnNameDB1 =  t2.ColumnNameDB2

我正在绞尽脑汁想弄清楚我做错了什么。

Answer 1

您可以尝试在连接级别显式指定排序规则。

SELECT t1.ColumnNameDB1, t2.ColumnNameDB2
FROM DB1.schema.TableName AS t1
INNER JOIN DB2.schema.TableName as t2
ON t1.ColumnNameDB1 =  LTRIM(RTRIM(t2.ColumnNameDB2)) COLLATE SQL_Latin1_General_CP1_CI_AS