Static data with special characters are reported as changed
vanonzen
Posts: 2
Hi,
we have a table with static data. This data is checked in once, but afterwards the data is constantly reported as changed.
Steps to reproduce:
1) Create a table Foo.Bar with 4 nvarchar(50) columns (Column1 till Column4, all together as primary key)
2) Check in the table in source control
3) Link the static data table to source control.
4) Insert the rows given as example below.
5) Check in static data
6) Refresh SQL Source Control
This record is marked as deleted and inserted with exactly the same statement.
INSERT INTO [Foo].[Bar] ([Column1], [Column2], [Column3], [Column4]) VALUES (N'Foo', N'BIO+', N'CHK', N'SRBU')
This record is marked as unchanged in the comparison-tool.
INSERT INTO [Foo].[Bar] ([Column1], [Column2], [Column3], [Column4]) VALUES (N'Foo', N'BIOx', N'CHK', N'SRBU')
All rows, which are falsely represented as "deleted and inserted", are rows with a plus or minus sign.
With regards,
we have a table with static data. This data is checked in once, but afterwards the data is constantly reported as changed.
Steps to reproduce:
1) Create a table Foo.Bar with 4 nvarchar(50) columns (Column1 till Column4, all together as primary key)
2) Check in the table in source control
3) Link the static data table to source control.
4) Insert the rows given as example below.
5) Check in static data
6) Refresh SQL Source Control
This record is marked as deleted and inserted with exactly the same statement.
INSERT INTO [Foo].[Bar] ([Column1], [Column2], [Column3], [Column4]) VALUES (N'Foo', N'BIO+', N'CHK', N'SRBU')
This record is marked as unchanged in the comparison-tool.
INSERT INTO [Foo].[Bar] ([Column1], [Column2], [Column3], [Column4]) VALUES (N'Foo', N'BIOx', N'CHK', N'SRBU')
All rows, which are falsely represented as "deleted and inserted", are rows with a plus or minus sign.
With regards,
Comments
What version of SQL Source Control are you using? I haven't been able to replicate this on 3.8.9.119. Maybe I've interpreted something incorrectly. Could you provide a script to create the table? This way I'll have an exact copy of the one that causes the problem.
Thanks.
Redgate Software