topic SQL Server 2005 Data Collation in QlikView https://community.qlik.com/t5/QlikView/SQL-Server-2005-Data-Collation/m-p/232696#M84285 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a problem with data collation... Or at least I think there is a problem.</P><P>SQL query returns an error</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />SELECT *<BR />FROM Table1<BR />WHERE NOT EXISTS (SELECT * FROM View2 WHERE View2.Text = Table1.Text)<BR /></PRE><BR /><BR /> <P><I>Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latvian_CI_AS" in the equal to operation.</I></P><P>But the data is loaded and <STRONG>partially</STRONG> joined in QV if I load from each table separately. But I need the data to be fully joined...</P><P>The solution would be to change the collation of data during the load... How to do it?</P><P></P></BODY></HTML> Fri, 05 Feb 2010 18:50:19 GMT 2010-02-05T18:50:19Z SQL Server 2005 Data Collation https://community.qlik.com/t5/QlikView/SQL-Server-2005-Data-Collation/m-p/232696#M84285 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a problem with data collation... Or at least I think there is a problem.</P><P>SQL query returns an error</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />SELECT *<BR />FROM Table1<BR />WHERE NOT EXISTS (SELECT * FROM View2 WHERE View2.Text = Table1.Text)<BR /></PRE><BR /><BR /> <P><I>Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latvian_CI_AS" in the equal to operation.</I></P><P>But the data is loaded and <STRONG>partially</STRONG> joined in QV if I load from each table separately. But I need the data to be fully joined...</P><P>The solution would be to change the collation of data during the load... How to do it?</P><P></P></BODY></HTML> Fri, 05 Feb 2010 18:50:19 GMT https://community.qlik.com/t5/QlikView/SQL-Server-2005-Data-Collation/m-p/232696#M84285 2010-02-05T18:50:19Z SQL Server 2005 Data Collation https://community.qlik.com/t5/QlikView/SQL-Server-2005-Data-Collation/m-p/232697#M84286 <HTML><HEAD></HEAD><BODY><P>Hi, more of a QlikView issue, it sounds to me like a table (or database) problem, in my experience you have to change the collation during the join task (SQL join), and then load the result in QlikView.</P><P>Rgds</P></BODY></HTML> Fri, 05 Feb 2010 20:21:19 GMT https://community.qlik.com/t5/QlikView/SQL-Server-2005-Data-Collation/m-p/232697#M84286 hector 2010-02-05T20:21:19Z