Forum Discussion

ea25's avatar
ea25
Copper Contributor
Aug 13, 2022

Serverless SQL Pool - Reading from Parquet - VARCHAR with UTF8 Collation - Data Getting Truncated

Currently have a Serverless SQL Pool within Synapse Analytics. I am working on a view which will get data from Parquet. The collation of the database is set to Latin1_General_100_BIN2_UTF8 as per MS ...
JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Aug 23, 2022

ea25 could you try to increase VARCHAR(60) to VARCHAR(600) and see would it be truncated? The number in VARCHAR is size in bytes and not size in characters so some special characters might occupy more than 1 byte per char.

Resources