topic How to COLLATE in TMSSQLOUT in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369871#M132980 <P>Hi Team, </P><P></P><P></P><P>I am using TMSSQLoutput component to insert data to MS SQL server table. </P><P>I am using vm_id as update key. </P><P></P><P></P><P>vm_id are as below </P><P>vm01abX</P><P>vm01ABx</P><P>vm02dcV</P><P>vm02DCV</P><P></P><P></P><P>If you observer they have different cases but while writing to table it consider </P><P>vm01abX and vm01ABx same. And data is getting over written. </P><P></P><P></P><P>How can i solve this for MS SQL Server or TMSSQLOUTPUT component. </P><P></P><P></P><P>In TSQL we have COLLATE option, Do we have any option in talend </P><P></P><P></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p000008vY9ZAAU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143778iE02AF796CD95E0B8/image-size/large?v=v2&amp;px=999" role="button" title="0693p000008vY9ZAAU.png" alt="0693p000008vY9ZAAU.png" /></span></P> Sat, 16 Nov 2024 01:50:46 GMT amtkmr1990 2024-11-16T01:50:46Z How to COLLATE in TMSSQLOUT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369871#M132980 <P>Hi Team, </P><P></P><P></P><P>I am using TMSSQLoutput component to insert data to MS SQL server table. </P><P>I am using vm_id as update key. </P><P></P><P></P><P>vm_id are as below </P><P>vm01abX</P><P>vm01ABx</P><P>vm02dcV</P><P>vm02DCV</P><P></P><P></P><P>If you observer they have different cases but while writing to table it consider </P><P>vm01abX and vm01ABx same. And data is getting over written. </P><P></P><P></P><P>How can i solve this for MS SQL Server or TMSSQLOUTPUT component. </P><P></P><P></P><P>In TSQL we have COLLATE option, Do we have any option in talend </P><P></P><P></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p000008vY9ZAAU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143778iE02AF796CD95E0B8/image-size/large?v=v2&amp;px=999" role="button" title="0693p000008vY9ZAAU.png" alt="0693p000008vY9ZAAU.png" /></span></P> Sat, 16 Nov 2024 01:50:46 GMT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369871#M132980 amtkmr1990 2024-11-16T01:50:46Z Re: How to COLLATE in TMSSQLOUT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369872#M132981 <P>@AmitKumar patil​&nbsp;, check the below link and while you creating the connection for the db in the metadata you can add in additional parameters.</P><P>&nbsp;</P><P><A href="https://help.talend.com/reader/S7xdkfRLcHpE~bSv4kuEGQ/r9kLIDA5uczOUs~fmKrTkQ" alt="https://help.talend.com/reader/S7xdkfRLcHpE~bSv4kuEGQ/r9kLIDA5uczOUs~fmKrTkQ" target="_blank">https://help.talend.com/reader/S7xdkfRLcHpE~bSv4kuEGQ/r9kLIDA5uczOUs~fmKrTkQ</A></P> Tue, 21 Jul 2020 17:21:23 GMT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369872#M132981 manodwhb 2020-07-21T17:21:23Z Re: How to COLLATE in TMSSQLOUT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369873#M132982 <P>Thanks i had a look but did not understand i exactly i have to do. </P><P>Could you give some screenshots</P> Wed, 22 Jul 2020 10:01:19 GMT https://community.qlik.com/t5/Talend-Studio/How-to-COLLATE-in-TMSSQLOUT/m-p/2369873#M132982 amtkmr1990 2020-07-22T10:01:19Z