https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350267#M129 <P>It's a current documented limitation. The hope is that this will be lifted.</P> Fri, 03 Jan 2025 21:03:02 GMT lbendlin 2025-01-03T21:03:02Z https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350255#M128 <P>When mirroring from Azure SQL to Fabric all Varchar columns are created on the mirrored database as VARCHAR(8000) instead of preserving their original sizes. Is this by design?</P> Fri, 03 Jan 2025 20:42:28 GMT https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350255#M128 AugustoChaves 2025-01-03T20:42:28Z https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350267#M129 <P>It's a current documented limitation. The hope is that this will be lifted.</P> Fri, 03 Jan 2025 21:03:02 GMT https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350267#M129 lbendlin 2025-01-03T21:03:02Z https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350270#M130 <P>I do see documentation of the limit of size for VARCHAR fields being 8000 and VARCHAR(MAX) is in public preview for warehouses but I can't find documentation that states that ALL FIELDS will be converted to VARCHAR(8000) during mirroring. Can you please point me to that doc?</P> Fri, 03 Jan 2025 21:05:26 GMT https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350270#M130 AugustoChaves 2025-01-03T21:05:26Z https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350291#M131 <P><A href="https://blog.gbrueckl.at/2024/01/using-varchar-in-microsoft-fabric-lakehouses-and-sql-endpoints/" target="_blank">Using VARCHAR() in Microsoft Fabric Lakehouses and SQL Endpoints – Gerhard Brueckl on BI &amp; Data</A></P> Fri, 03 Jan 2025 21:17:09 GMT https://community.fabric.microsoft.com/t5/SQL-database/VARCHAR-8000/m-p/4350291#M131 lbendlin 2025-01-03T21:17:09Z