View Issue Details

IDProjectCategoryView StatusLast Update
0002558SymmetricDSBugpublic2020-07-22 17:56
Reportergilles.riand Assigned To 
Prioritynormal 
Status closedResolutionno change required 
Product Version3.7.32 
Summary0002558: MSQLSERVER nvarchar field is scramble (???) at target
DescriptionTry to replic a TABLE with SQLServer 2014

with a Field for exemple 'NAME' in nvarchar(50)

if you put this text : 'ជំរាបសួរ' in the field.... you will get '?????' in the remote node

Because the field sym_data is typed as text and not in ntext !


Tagscharacter encoding, dialect: sql-server

Relationships

related to 0001766 closedchenson nvarchar data can be corrupted when the default database collation is set to a value that does not support double byte character 

Activities

elong

2016-04-15 19:58

developer   ~0000783

Try setting this property in your engine properties file:

mssql.use.ntypes.for.sync=true

toilv

2019-09-21 15:08

reporter   ~0001604

i tried mssql.use.ntypes.for.sync=true but the unicode data sent to destination node still error

elong

2020-05-20 18:15

developer   ~0001717

After you change parameter to mssql.use.ntypes.for.sync=true, you need to restart SymmetricDS. It should alter sym_data to use ntext type for row_data, old_data, and pk_data fields. Also, force the triggers to rebuild so they handle character data with nvarchar by running "symadmin sync-triggers -f".

Issue History

Date Modified Username Field Change
2016-04-11 13:48 gilles.riand New Issue
2016-04-15 19:58 elong Note Added: 0000783
2019-04-24 12:36 elong Tag Attached: data sync
2019-04-24 12:36 elong Tag Attached: dialect: mssql
2019-04-24 12:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2019-04-26 13:31 elong Tag Attached: character encoding
2019-04-26 13:31 elong Tag Detached: data sync
2019-05-09 15:08 elong Assigned To => elong
2019-05-09 15:08 elong Status new => feedback
2019-05-09 15:09 elong Assigned To elong =>
2019-05-09 15:10 elong Summary MSQLSERVER et UTF8 => MSQLSERVER nvarchar field is scramble (???) at target
2019-09-21 15:08 toilv Note Added: 0001604
2020-05-20 18:12 elong Relationship added related to 0001766
2020-05-20 18:15 elong Note Added: 0001717
2020-07-22 17:56 elong Status feedback => closed
2020-07-22 17:56 elong Resolution open => no change required