I create a table and commit both the table and static data using source control 4.1.81.41 standard.
After commit, source control continues to inform me one row is different between source control and my database.
To re-produce: -
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
SET ANSI_PADDING ON;
SET NOCOUNT ON;
IF EXISTS ( SELECT 1
FROM sys.tables
WHERE [object_id] = OBJECT_ID(N'dbo.ThisIsATestTable') )
BEGIN;
DROP TABLE dbo.ThisIsATestTable;
END;
CREATE TABLE dbo.ThisIsATestTable
(
[Category] [NVARCHAR](64) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
Age TINYINT NOT NULL ,
CONSTRAINT PK_ThisIsATestTable PRIMARY KEY ( [Category] )
);
INSERT INTO dbo.ThisIsATestTable
VALUES ( N'X – Y', 3 ), -- note the delimiter here is ascii code 150 "En dash"
( N'X - Y Z', 7 ); -- note the delimiter here is ascii code 45 "Hyphen"
Post commit, the row where Category = N'X - Y Z' will always be identified as different so my source control always appears out of date. After clicking the commit button, I get an error saying there is nothing to commit.
How do I fix this please?
Many thanks, Andy Jones.
After commit, source control continues to inform me one row is different between source control and my database.
To re-produce: -
SET ANSI_NULLS ON; SET QUOTED_IDENTIFIER ON; SET ANSI_PADDING ON; SET NOCOUNT ON; IF EXISTS ( SELECT 1 FROM sys.tables WHERE [object_id] = OBJECT_ID(N'dbo.ThisIsATestTable') ) BEGIN; DROP TABLE dbo.ThisIsATestTable; END; CREATE TABLE dbo.ThisIsATestTable ( [Category] [NVARCHAR](64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , Age TINYINT NOT NULL , CONSTRAINT PK_ThisIsATestTable PRIMARY KEY ( [Category] ) ); INSERT INTO dbo.ThisIsATestTable VALUES ( N'X – Y', 3 ), -- note the delimiter here is ascii code 150 "En dash" ( N'X - Y Z', 7 ); -- note the delimiter here is ascii code 45 "Hyphen"Post commit, the row where Category = N'X - Y Z' will always be identified as different so my source control always appears out of date. After clicking the commit button, I get an error saying there is nothing to commit.
How do I fix this please?
Many thanks, Andy Jones.