topic Re: Non unicode characters in Qlik Replicate

Non unicode characters

luigi_c — Sat, 16 Nov 2024 00:31:23 GMT

Hello,

I'm trying to load my data from my SAP system to my SQL server 2016 database. The tasks and CDC are working well but there are some non unicode characters that I am not able to store correctly in my target database.

Example of these special characters are:

Ğ
Ç
Ö
Ü

They are stored in my SQL server database with this character "?".

Those values are stored in some primary fields and give me the following error:

"Handling End of table *TABLE_NAME* loading failed by subtask 1 thread 1
Commit rows failed
RetCode: SQL_SUCCESS SqlState: 23000 NativeError: 2627 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint *TABLE_NAME*. Cannot insert duplicate key in object *TABLE_NAME*. The duplicate key value is (XXX, XXX, XXX, ?)."

Can anyone point me one direction to check what can be done to solve this?

Many thanks in advance.

Re: Non unicode characters

Madhavi_Konda — Fri, 12 Jun 2020 20:23:39 GMT

Hi,
Did you check your SQL server collation? Are you able to manually enter the unicode characters into your tables?

Thanks,
Madhavi

Re: Non unicode characters

luigi_c — Mon, 15 Jun 2020 08:21:50 GMT

Hello Madhavi,

yes I tried to change SQL server collation and I tested these characters into my tables. I used another extractor and it works. Do you know if there is a Attunity internal parameter to change the default utf-16 encoding in Attunity?

Many thanks for your reply,

Luigi

Re: Non unicode characters

Madhavi_Konda — Tue, 16 Jun 2020 20:21:36 GMT

Hi Luigi,

Please open a support case. Thank you