View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006632 | SymmetricDS | Improvement | public | 2024-10-31 17:58 | 2024-10-31 18:06 |
Reporter | pbelov | Assigned To | pbelov | ||
Priority | low | ||||
Status | confirmed | Resolution | open | ||
Product Version | 3.15.0 | ||||
Summary | 0006632: Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS tables for SQL Server | ||||
Description | Convert 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 Reproduce | Currently, 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 Information | CREATE 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: '?'. | ||||
Tags | dialect: sql-server | ||||
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 |