View Revisions: Issue #6632
Summary | 0006632: Convert to Unicode-friendly NVARCHAR type all internal SymmetricDS tables for SQL Server | ||
---|---|---|---|
Revision | 2024-10-31 18:06 by pbelov | ||
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: '?'. |
||
Revision | 2024-10-31 17:58 by pbelov | ||
Additional Information |