topic Setting collation property via qlik replicate in Qlik Replicate

Setting collation property via qlik replicate

Learner12 — Wed, 23 Oct 2024 15:10:53 GMT

Could you please guide if there is a setting to specify collation property at target while replicating from 1 sqlserver to other. We want to override source property at replicated target.

Re: Setting collation property via qlik replicate

sureshkumar — Thu, 24 Oct 2024 01:24:19 GMT

Hello @Learner12

Usually, collation will be set at the target side based on the characters used at the source side.
We need to understand the Task configurations and Target database configurations and based on that we can suggest.

I would suggest opening a support ticket with us to analyze further.

Regards,

Suresh

Re: Setting collation property via qlik replicate

john_wang — Mon, 28 Oct 2024 14:07:54 GMT

Hello @Learner12 ,

Thanks for reaching out to Qlik Community!

Please take note that in SQL Server the collation is a bit different with other RDBMS. In SQL Server there are only 2 level collations: database-level, and column-level. (there is NOT table-level collations). When you create or alter a table, you can specify collations for each character-string column by using the COLLATE clause. If you don't specify a collation, the column is assigned the default collation of the database.

So far you may set the database COLLATE and Qlik Replicate inherits it.

Hope this helps.

John.