无法解决“Latin1_General_CI_AI”与“Latin1_General_CI_AI”之间的整理冲突。和“SQL_Latin1_General_CP1_CI_AS”和“SQL_Latin1_General_CP1_CI_AS”在等于操作。 [英] Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

问题描述

listBox1.Items.Clear();         
            cmd = new SqlCommand("SELECT SimNo FROM PurchaseEntry AS t1 WHERE country ='" + cmbcountry.SelectedItem.ToString() + "'and (IMEINo = 'N/A')and  (SimNo NOT IN   (SELECT others FROM challanout AS t2 )) and status!='"+"IN USE"+"'", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "cout");
            int i = ds.Tables[0].Rows.Count;
            for (int t = 0; t < i; t++)
            {
                listBox1.Items.Add(ds.Tables[0].Rows[t][0].ToString());
                listBox1.Width = cmbitemtype.Width;
                listBox1.Height = Convert.ToInt32(listBox1.ItemHeight * i) + 10;
            } 

我收到错误

I am getting error in line

da.fill

that

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

请帮忙谢谢....

Please any help Thank you....

推荐答案

这个错误说你的TempDB和ProductionDB的整理是不同的。

你应该使用正确的排序规则创建SQL Server临时表 [ ^ ]。



另请查看：修复整理：实验 [ ^ ]





我希望，这应该足以让你理解这个问题了。

- Amit

This error says collation of your TempDB and ProductionDB are different.
You should Create SQL Server temporary tables with the correct collation[^].

Also check : Fixing Collation: The Experiments[^]


I hope, this should be enough for you to understand the problem.

--Amit

这篇关于无法解决“Latin1_General_CI_AI”与“Latin1_General_CI_AI”之间的整理冲突。和“SQL_Latin1_General_CP1_CI_AS”和“SQL_Latin1_General_CP1_CI_AS”在等于操作。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！