Non unicode characters

[luigi_c]

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.

[Madhavi_Konda]

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

Thanks,
Madhavi

[luigi_c]

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 

[Madhavi_Konda · Accepted solution]

Hi Luigi,

Please open a support case. Thank you