title: Android - no such collation sequence: SQL_Latin1_General_CP1_CI_AS
body: <p>I'm developing an android application where I need to use the query below ,</p>
  
  <pre><code>SELECT distinct AttributeValue.AttributeValueName as InventoryId
      ,WorkFlowTransaction.WorkFlowTransId
      ,Client.ClientName
      ,Project.ProjectName
      ,Product.ProductName 
  FROM WorkFlowTransaction 
  JOIN AttributeValue 
      ON WorkFlowTransaction.WorkflowTransId = AttributeValue.WorkflowTransId 
  JOIN Attribute 
      on Attribute.AttributeId = AttributeValue.AttributeId 
  JOIN Product 
      on Product.ProductId = WorkFlowTransaction.ProductId 
  JOIN Client 
      ON Client.ClientID=WorkFlowTransaction.ClientId 
  JOIN Project 
      on Project.ProjectID=WorkFlowTransaction.ProjectId 
  where AttributeValue.AttributeValueName 
      COLLATE SQL_Latin1_General_CP1_CI_AS not in (
                                   Select LocationId 
                                   from BarcodeDetails 
                                               ) 
      and Attribute.AttributeName = 'Inventory Id'
      and WorkFlowTransaction.ClientId = 2 
      and WorkFlowTransaction.ProjectId = '44' 
      and WorkFlowTransaction.ProductId = '47' 
      and Attribute.IsDeleted ='0' 
      and AttributeValue.IsDeleted ='0' 
      and WorkFlowTransaction.IsDeleted = '0'
  </code></pre>
  
  <p>This Query is working fine in <code>SQL-Server</code> .But  <code>no such collation sequence: SQL_Latin1_General_CP1_CI_AS</code> exception thrown in android .<br/> Please help me out giving your idea or solution .</p>