Issue
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
Data in Tableau Desktop
Last Modified Date: 23 Jun 2023
Environment
- Tableau Desktop
- Microsoft SQL Server
Resolution
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
Cause
The collation in Microsoft SQL Server was set to be case-insensitive. For the collation in Microsoft SQL Server, refer to the following website.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials