Solved: Is it possible to change Collation during Replicat... - Qlik Community

BFasano

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

mrsimon007

No, you can’t change collation during replication. The subscriber must match the publisher’s collation. If you need a different collation, you’ll have to handle it with a separate process like ETL or by converting after the data is replicated.

View solution in original post

DesmondWOO

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

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

mrsimon007

No, you can’t change collation during replication. The subscriber must match the publisher’s collation. If you need a different collation, you’ll have to handle it with a separate process like ETL or by converting after the data is replicated.

BFasano

Thank you,

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

mrsimon007

Welcome

Is it possible to change Collation during Replication?

Functionality