Hi, It would be great to have lakehouse and warehouse support different collations, specifically case sensitive and case insensitive. At the moment we are able to create objects that are n...
The Fabric Roadmap seems to indicate this will be available for Warehouses in Q3 2024:
- https://learn.microsoft.com/en-us/fabric/release-plan/data-warehouse#case-insensitive-collation-support
Hopefully the same is coming for Lakehouses??
Case insensitive collation support (in Warehouse)
Estimated release timeline: Q3 2024
Using the public REST APIs to create a Data Warehouse includes a new option to set the default collation. This can be used to set a new Case Insensitive Collation default. You'll also be able to use the COLLATE command with CREATE TABLE to directly control which collation your VARCHAR fields use. The two supported collations are Latin1_General_100_CI_AS_KS_WS_SC_UTF8 (which is Case Insensitive) and Latin1_General_100_BIN2_UTF8 (which is Case Sensitive) and continues to be our default.
