Hi,

We would like to know how can we insert a body with more than 2000+ character from outlook to database.

If our character length set to more than 2000+ characters, the dB type in configuration became blob varchar.

and when we try sync, this is the error:

37000 [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot convert to text/ntext or collate to
'Latin1_General_100_CI_AI_SC' because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types
varchar(max), nvarchar(max) or a collation which does not have the SC or UTF8 flags.

According to the error message, there is a problem with conversion of Unicode to your db collation.
Please change your DB column type to nvarchar(max) , open your GeniusConnect config (Assign table dialog) and re-save to reflect the db changes (GeniusConnect stores db column types and lenght).

Please also update your ODBC driver.

For more details on this error, Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?...