Forum Discussion
Fabric SQL Database Mirroring Error With Large Columns
Hi blull,
Did this field define with VARCHAR(max) or other size that larger than VARCHAR(8000)? AFAIK, current the data warehouse support the VARCHAR(8000) type.
Troubleshoot Fabric mirrored databases - Microsoft Fabric | Microsoft Learn
Some of the data in my column appears to be truncated
The Fabric warehouse does not support VARCHAR(max) it only currently supports VARCHAR(8000).You may need to split them to multiple fields or waiting for the next release for add support with VARCHAR(max).
Feature Estimated release timeline VARCHAR(MAX)/VARBINARY(MAX) types Q3 2024 Regards,
Xiaoxin Sheng
Hi blull,
Did this field define with VARCHAR(max) or other size that larger than VARCHAR(8000)? AFAIK, current the data warehouse support the VARCHAR(8000) type.
Troubleshoot Fabric mirrored databases - Microsoft Fabric | Microsoft Learn
Some of the data in my column appears to be truncated
The Fabric warehouse does not support VARCHAR(max) it only currently supports VARCHAR(8000).
You may need to split them to multiple fields or waiting for the next release for add support with VARCHAR(max).
| Feature | Estimated release timeline |
| VARCHAR(MAX)/VARBINARY(MAX) types | Q3 2024 |
Regards,
Xiaoxin Sheng