topic Is it possible to change Collation during Replication? in Qlik Replicate

Is it possible to change Collation during Replication?

BFasano — Tue, 07 Oct 2025 15:47:46 GMT

Hi all,

Looking for some guidance here. We have a source database that is in SQL_Latin1_General_CP850_CS_AS.

Is there a way to change it to SQL_Latin1_General_CP1_CI_AS in the Qlik Replication task? Or in the Target Database settings?

Thanks,

-Brian

Re: Is it possible to change Collation during Replication?

DesmondWOO — Wed, 08 Oct 2025 03:32:33 GMT

Hi @BFasano ,

Thank you for reaching out to the Qlik Community.

From my understanding, the extended ASCII characters in code pages CP850 and CP1252 differ. How will you handle this? If you plan to use NCHAR/NVARCHAR on the target SQL Server, Qlik Replicate should work fine.

Regards,
Desmond

Re: Is it possible to change Collation during Replication?

BFasano — Wed, 08 Oct 2025 18:52:26 GMT

Thank you,

I was able to handle the coversion during the move from Raw to Stage in our ODS.