Forum Discussion
link for fabric case sensitive issue
Hi mama_Hani,
In warehouses and lakehouses, everything is case sensitive by default. This was also a bit of a struggle for me and my team coming from a SQL Server environment where things are not case sensitive by default.
You can change the collation in the warehouse to be case insensitive: https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi mama_Hani,
In warehouses and lakehouses, everything is case sensitive by default. This was also a bit of a struggle for me and my team coming from a SQL Server environment where things are not case sensitive by default.
You can change the collation in the warehouse to be case insensitive: https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
thanks a lot; i tried and it does work;
do you know when was this introduced?
Setting the collation for the Fabric Warehouse has been possible for a long time. However, it was only possible to create a warehouse with a different collation via Rest API.
For a good 1-2 months now, this has also been possible natively via the GUI.
Best regards
