title: Insert "Golf" fails in SQL Server with error unclosed quotation mark
body: <p>Very simple table and insert statement, fails if the string is 'Golf', but works for any other string.
  Table create:</p>
  
  <pre><code>CREATE TABLE [dbo].[market]
  (
      [marketID] [int] NOT NULL,
      [name] [varchar](50) NULL,
  CONSTRAINT [PK_market] PRIMARY KEY CLUSTERED ([marketID] ASC)
  )
  </code></pre>
  
  <p>Insert:</p>
  
  <pre><code>INSERT [dbo].[market] ([marketID], [name]) VALUES (4, N'Golf')
  
  Error: Unclosed quotation mark after the character string ''. (State:37000, Native Code: 69)
  Error: Incorrect syntax near ''. (State:37000, Native Code: 66)
  Error: Unclosed quotation mark after the character string ')'.
  </code></pre>
  
  <p>Now, if I change the insert to:</p>
  
  <pre><code>INSERT [dbo].[market] ([marketID], [name]) VALUES (4, N'Test')
  </code></pre>
  
  <p>It works just fine.  Has anyone ever seen that before?</p>