topic Re: How to Change SQL Select Collate In Qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286890#M623265 <HTML><HEAD></HEAD><BODY><P>Simply use</P><P></P><P>SQL SELECT "Col_ntext" </P><P>FROM Test.dbo.TestCollation;</P></BODY></HTML> Sat, 07 Jan 2017 12:02:41 GMT MK_QSL 2017-01-07T12:02:41Z How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286889#M623264 <HTML><HEAD></HEAD><BODY><P>hi </P><P>i want change sql collate in qlikview</P><P>but get error</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148646_Untitled.png" style="height: 349px; width: 620px;" /></P></BODY></HTML> Sat, 07 Jan 2017 11:29:04 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286889#M623264 Anonymous 2017-01-07T11:29:04Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286890#M623265 <HTML><HEAD></HEAD><BODY><P>Simply use</P><P></P><P>SQL SELECT "Col_ntext" </P><P>FROM Test.dbo.TestCollation;</P></BODY></HTML> Sat, 07 Jan 2017 12:02:41 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286890#M623265 MK_QSL 2017-01-07T12:02:41Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286891#M623266 <HTML><HEAD></HEAD><BODY><P>i want change collation in qlikview</P><P>my access is read to SQL</P><P>Data Type is varchar But Save Unicode Data</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148647_Untitled.png" style="height: auto;" /></P></BODY></HTML> Sat, 07 Jan 2017 12:04:56 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286891#M623266 Anonymous 2017-01-07T12:04:56Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286892#M623267 <HTML><HEAD></HEAD><BODY><P>SQL SELECT "Col_ntext" COLLATE Persion_100_BIN</P><P>FROM <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FROM Test.dbo.TestCollation;</SPAN></P><P></P><P>Remove 'as'</P></BODY></HTML> Sat, 07 Jan 2017 12:08:50 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286892#M623267 vinieme12 2017-01-07T12:08:50Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286893#M623268 <HTML><HEAD></HEAD><BODY><P>Then Remove as ...</P><P>as per @<A _jive_internal="true" data-avatarid="13162" data-externalid="" data-online="false" data-presence="null" data-userid="216189" data-username="vinieme12" href="https://community.qlik.com/people/vinieme12" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;">Vineeth Pujari</A><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"> </SPAN></P></BODY></HTML> Sat, 07 Jan 2017 12:18:25 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286893#M623268 MK_QSL 2017-01-07T12:18:25Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286894#M623269 <HTML><HEAD></HEAD><BODY><P>The problem is displayed data</P><P></P><P>SQL Server </P><P><IMG alt="Untitled111.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148649_Untitled111.png" style="height: auto;" /></P><P></P><P></P><P>Qlikview</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/148650_Untitled.png" style="height: auto;" /></P><P></P><P>Becasue SQL Data Taype Is Varchar</P><P>But Persian Data Is Saved</P></BODY></HTML> Sat, 07 Jan 2017 12:32:26 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286894#M623269 Anonymous 2017-01-07T12:32:26Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286895#M623270 <HTML><HEAD></HEAD><BODY><P>Try</P><P style="font-size: 13.3333px;">SQL SELECT "Col_ntext" COLLATE <SPAN class="str" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #008800;">Persian_100_CS_AI_WS</SPAN></P><P style="font-size: 13.3333px;">FROM <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FROM Test.dbo.TestCollation;</SPAN></P></BODY></HTML> Sat, 07 Jan 2017 12:43:57 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286895#M623270 vinieme12 2017-01-07T12:43:57Z Re: How to Change SQL Select Collate In Qlikview https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286896#M623271 <HTML><HEAD></HEAD><BODY><P>Appearance is not correct</P><P>Again, the question mark</P></BODY></HTML> Sat, 07 Jan 2017 12:48:08 GMT https://community.qlik.com/t5/QlikView/How-to-Change-SQL-Select-Collate-In-Qlikview/m-p/1286896#M623271 Anonymous 2017-01-07T12:48:08Z