How to deal with unicode data ?

Database Replication, Filtered Synchronization, and Transformation

Brought to you by: chenson42, erilong, gwilmer, josh-a-hicks, and 4 others

How to deal with unicode data ?

Forum: Help

Creator: David Lee

Created: 2019-09-20

Updated: 2019-09-27

David Lee - 2019-09-20

I have a postgresql data have some unicode tables.
I have already setup successful for replication but can not send origin unicode data to SQL server.
I have already tried using mssql.use.ntypes.for.sync=true but still be error.
Could someone help me ?
Thanks

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Lee - 2019-09-21

Any body help?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Michalek - 2019-09-25

David, maybe this article would help:
https://medium.com/data-weekly/character-sets-and-symmetricds-c8f4c3ac6d4

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Lee - 2019-09-26

Yes, i use the mssql.use.ntypes.for.sync=true from that article

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Lee - 2019-09-27

Well, i just found a problem here:
My properties file seem both set sendStringParametersAsUnicode=false
Does it impact if i set it to "sendStringParametersAsUnicode=true"

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Lee - 2019-09-27

Well it seem works but i see it has a big impact to performance of symmetricds.
High pressure washer task

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.