Saturday, 24 March 2012

Collation issue : Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation.

Hi,

I faces issue Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation.

My application is developed for English and Chinese language.One of my report was working fine in English server but on chinese server it was giving error.

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

I analysed the report and find out that there is error in my sp which is not returning the values.

then updated my sp and in where clause where i was comparing the values from the equal to operator.
i put collate Chinese_PRC_CI_AI on both side and worked well.

I hope it will be helpfull to you.