Forum Discussion
Lakehouse SQL Endpoint (db) Collation
Is it possible to make the whole SQL db made from Lakehouse to be case-insensitive?
I know that it works on field basis when running the query -
Hi koltonist
Unfortunately, it's not possible to make case insensitive collation for the whole sql db created from lakehosue. The SQL endpoint of Fabric lakehouse, the default is case-sensitive. as said by you collation works for specific fields in quries.
If you want to set case insensitive for entire databases, it could be done with Fabric warehouses. Can you please go thorugh this thread How To: Create Warehouses with Case-Insensitive (CI) Collation - Microsoft Fabric | Microsoft Learn it might helps you.
Thank you!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
1 Reply
Hi koltonist
Unfortunately, it's not possible to make case insensitive collation for the whole sql db created from lakehosue. The SQL endpoint of Fabric lakehouse, the default is case-sensitive. as said by you collation works for specific fields in quries.
If you want to set case insensitive for entire databases, it could be done with Fabric warehouses. Can you please go thorugh this thread How To: Create Warehouses with Case-Insensitive (CI) Collation - Microsoft Fabric | Microsoft Learn it might helps you.
Thank you!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!