Unable to resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in equal to oper

yk04903

Create Table #a (Sonum char (10))
Insert Into #a (Sonum)
select '05 / 6525 '
 
select a. * from sohead a inner join #a on a.so_num = # a.Sonum

Could not resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in equal to operation.
Ask how to solve

我是杀人狂

Can only be changed like this
select * from sohead where so_num in (select Sonum as so_num from #a)

dream88

select a. * from sohead a inner join #a on a.so_num COLLATE database_default
= # a.Sonum COLLATE database_default

yk04903

Tried, but this error occurred again: an expression of non-Boolean type was specified in the context where the condition should be used (near 'COLLATE').

Can you tell me why?

modestpr

The collate of the table sohead field so_num is different from the default collate of the database. Create a temporary table and use the default collate of the database for the character type field. If the collate of the field of the table is different, SQL Server cannot perform the two fields. Compare

Solution: Change the collate of the sohead field so_num to be consistent with the default of the database, or change the default Collate of the database, or specify Collate when creating the temporary table

sunnyboycs

Choose which database of yours, right-click properties, there is a sorting rule under that option setting, just change it

69124813

Database Properties>Options>Collation>Chinese_PRC_CI_AS

OK

mrlee321

It may be that the wrong character set was selected when SQL was installed, or the compatibility of SQL was set to be compatible (but it is risky, I dare not set it randomly)