/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
SAP Data Services optimized SQL contains the following SQL for an ORDERBY:
ORDER BY "TCRdr_8"."Col2" COLLATE Latin1_General_BIN2 ASC
Even though the source, target and repository database are using the collation Latin1_General_CS_AS and the SAP Data Services AL_Engine is set to <default>_<default>.<default> in the DSConfig.txt
Read more...
Environment
- SAP Data Services 14.2.x
- Microsoft SQL Server 2016
Product
SAP Data Services 4.2
Keywords
DS, TC, SQL, Optimized, COLLATE, orderby, Latin1_General_BIN2, function, Table_comparison, , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)