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
2 Replies
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 ,
Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng