GitHub user hb0313 added a comment to the discussion: Databricks -> PowerBi 
(Fabric) support for COLLATE UTF8_LCASE type

So I went ahead and did some more digging on my end and looks like the default 
implementation uses ODBC which why the UTF8_LCASE collated data type is 
supported, but when switching to 2.0 which is actually ADBC 2.0 beta version, 
their is no support of collated data type.

<img width="1670" height="460" alt="image" 
src="https://github.com/user-attachments/assets/434e237e-58f2-4ca0-b563-d7e07f0f6795";
 />
Source - 
https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi-adbc#adbc

Fabric introduced support for collation recently - 
https://blog.fabric.microsoft.com/en-us/blog/announcing-full-collation-support-for-sql-databases-in-microsoft-fabric-preview/#
 

GitHub link: 
https://github.com/apache/arrow-adbc/discussions/4245#discussioncomment-16653118

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to