Uppercase and Lowercase Characters are not Recognized as Different When Connecting to Microsoft SQL Server

Published: 21 Jun 2023
Last Modified Date: 23 Jun 2023


In a mixed-case field of Microsoft SQL Server data, the values are not distinguished as different for the same word.

Data in Microsoft SQL Server
User-added image

Data in Tableau Desktop
User-added image


  • Tableau Desktop
  • Microsoft SQL Server


Work with your Database Administrator to change the collation in Microsoft SQL Server. Setting collations are supported at the following levels of an instance of SQL Server:
Below is a sample query for changing the Column-level collations:
ALTER TABLE dbo.<table name> ALTER COLUMN "<column name>" [<data type>](<digit>) COLLATE <collation>

ALTER TABLE dbo.test ALTER COLUMN "Value" [nvarchar](30) COLLATE Japanese_CS_AS


The collation in Microsoft SQL Server was set to be case-insensitive. For the collation in Microsoft SQL Server, refer to the following website.
Did this article resolve the issue?