Skip to main content
Documentation
Feature Requests Trust Center Status Community

Community

Other: Azure SQL Refresh Issue

Saikat Manna User

Issue: Error while refresh azure Target. 

[SQL Server]Cannot convert to text/ntext or collate to 'Latin1_General_100_CS_AS_SC_UTF8' 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

[hvr_rrprismdim_as_p_usc_1] ( \
[tbl_name] varchar(124) default '' not null, \
[recov_label] varchar(16) default '' not null, \
[recov_seq] int default 0 not null, \
[recov_sub_seq] int default 0 not null, \
[recov_abort] datetime default '01-jan-1900 00:00:00' not null, \
[recov_sql] text default '' not null \
)]. \

Available Workaround: The job table needs to be created manually with varchar(max) datatype instead of text depending on the collation set up on Azure SQL database

Proposed Improvement: Generate DDL automatically based on the collation set up on Azure SQL

 

 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Mark Van de Wiel Fivetranner

    Hi Saikat,

    Thank you for reporting this. I agree that we should create a state table that just works out-of-the-box.

    Best regards,
    Mark.

  • Saikat Manna User

    Thanks Mark. Is there a plan to implement this in near future?

Didn’t find what you need?

Contact support