title: Trademark Symbol not rendering in SQL Server 2014
body: <p>On my SQL Server 2014 instance, if I run </p>
  
  <pre><code>select @@version
  select 'None of your Business™'
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>----------------------------------------------------------------------------------------------------------------------------------------------------------
  
      ------------------------------------------------------------------------------------------------------
      Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) 
          Jun 17 2016 19:14:09 
          Copyright (c) Microsoft Corporation
          Enterprise Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)
  
  (1 row affected)
  
  
      ----------------------
      None of your BusinessT
  </code></pre>
  
  <p>(1 row affected)</p>
  
  <p>On my local SQL Server 2017 if I run </p>
  
  <pre><code>select @@version
  select 'None of your Business™'
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>-----------------------------------------------------------------------------
  
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) 
          Aug 22 2017 17:04:49 
          Copyright (C) 2017 Microsoft Corporation
          Developer Edition (64-bit) on Windows 10 Enterprise 10.0 &lt;X64&gt; (Build 17763: ) (Hypervisor)
  
  
  (1 row affected)
  
  
  ----------------------
  None of your Business™
  
  (1 row affected)
  </code></pre>
  
  <p>Does SQL Server 2014 just not handle this character?  Other than upgrading to SQL Server 2014 is there a patch or anything to get it work with this?  Is there a way to modify a query to work with both versions?  </p>
  
  <pre><code>select CHAR(0153)
  </code></pre>
  
  <p>renders as a ™ in SQL Server 2017, but as a Ö in SQL Server 2014.</p>