Forum Discussion

koltonist's avatar
koltonist
Regular Visitor
1 year ago
Solved

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 -  WHERE Company = 'myCompanY'COLLATE Latin1_General_...
one lake
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    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!

suparnababu8's avatar
suparnababu8
Super User
1 year ago

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!