View Issue Details

IDProjectCategoryView StatusLast Update
0002558SymmetricDSBugpublic2019-09-21 11:08
Reportergilles.riandAssigned To 
Prioritynormal 
Status feedbackResolutionopen 
Product Version3.7.32 
Target VersionFixed in Version 
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

Activities

elong

2016-04-15 15:58

developer   ~0000783

Try setting this property in your engine properties file:

mssql.use.ntypes.for.sync=true

toilv

2019-09-21 11:08

reporter   ~0001604

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

Issue History

Date Modified Username Field Change
2016-04-11 09:48 gilles.riand New Issue
2016-04-15 15:58 elong Note Added: 0000783
2019-04-24 08:36 elong Tag Attached: data sync
2019-04-24 08:36 elong Tag Attached: dialect: mssql
2019-04-24 08:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2019-04-26 09:31 elong Tag Attached: character encoding
2019-04-26 09:31 elong Tag Detached: data sync
2019-05-09 11:08 elong Assigned To => elong
2019-05-09 11:08 elong Status new => feedback
2019-05-09 11:09 elong Assigned To elong =>
2019-05-09 11:10 elong Summary MSQLSERVER et UTF8 => MSQLSERVER nvarchar field is scramble (???) at target
2019-09-21 11:08 toilv Note Added: 0001604