View Issue Details

IDProjectCategoryView StatusLast Update
0006632SymmetricDSImprovementpublic2024-10-31 18:06
Reporterpbelov Assigned Topbelov  
Prioritylow 
Status confirmedResolutionopen 
Product Version3.15.0 
Summary0006632: Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS tables for SQL Server
DescriptionConvert to Unicode-friendly NVARCHAR any and all columns which currently use VARCHAR (on all SymmetricDS internal tables) when using MS SQL Server database.
Also, set the following engine parameter to true by default:
mssql.use.ntypes.for.sync=true

Steps To ReproduceCurrently, when database is MS SQL Server, schema for SymmetricDS internal tables gets evaluated to:
1. When the mssql.use.ntypes.for.sync=true
   the sym_data table uses Unicode-friendly NTEXT column type.
2. When the mssql.use.ntypes.for.sync=false
   all sym_data table use non-Unicode column types.
Additional InformationCREATE TABLE SymQaRoot.dbo.test_unicode_nvarchar_max(
    id int NOT NULL
    ,nvarchar_max nvarchar(max) NULL
    ,nvarchar_4000 nvarchar(4000) NULL
    ,PRIMARY KEY (id)
);
-- Set up replication for this table, then insert data with Unicode characters:
INSERT INTO SymQaRoot.dbo.test_unicode_nvarchar_max VALUES (11, 'NOTHING_special!', 'NOTHING_special!0');
INSERT INTO SymQaRoot.dbo.test_unicode_nvarchar_max VALUES (22, N'Cyrillic=Привет', N'Cyrillic=Привет'); -- Eg. Cyrillic alphabet

-- Query to detect when Unicode characters get "dropped":
SELECT * FROM SymQaRoot.dbo.test_unicode_nvarchar_max
WHERE CAST(nvarchar_max AS VARCHAR(max)) <> [nvarchar_max];

-- Confirm that the CSV data in the staging area uses Unicode support (at the file level) and does not convert Unicode characters to question marks: '?'.
Tagsdialect: sql-server

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2024-10-31 17:58 pbelov New Issue
2024-10-31 17:58 pbelov Status new => assigned
2024-10-31 17:58 pbelov Assigned To => pbelov
2024-10-31 17:59 pbelov Status assigned => confirmed
2024-10-31 17:59 pbelov Summary Convert to NVARCHAR from any VARCHAR tables in SymmetricDS for SQL Server => Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS table for SQL Server
2024-10-31 17:59 pbelov Description Updated View Revisions
2024-10-31 18:00 pbelov Tag Attached: dialect: sql-server
2024-10-31 18:06 pbelov Additional Information Updated View Revisions
2024-10-31 18:06 pbelov Summary Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS table for SQL Server => Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS tables for SQL Server