title: Linq to SQL Insert trademark "™" Symbol
body: <p>I want to insert a string with trademark symbol (™) to MSSQL 2008. </p>
  
  <p>When I was searching the problem I found some SQL based solutions:</p>
  
  <p>Trimming the symbol:</p>
  
  <pre><code>SELECT REPLACE('Microsoft™',char(153),'')
  </code></pre>
  
  <p>Insert only the symbol:</p>
  
  <pre><code>INSERT mytable(col1) VALUES (char(153))
  </code></pre>
  
  <p>Also I have read <a href="https://stackoverflow.com/questions/3778556/sqlite-insert-special-symbols-trademark-into-table">this</a> question but I can't find a solution. </p>
  
  <p>Is there any way to insert a word with the symbol (like 'Microsoft™') using <strong>Linq to SQL</strong>?</p>
  
  <p>I made my trials on a nvarchar column.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>This is my table:</p>
  
  <p><img src="https://i.stack.imgur.com/jaAjM.png" alt="Sellers table"></p>
  
  <p>This is my mapping at dbml:</p>
  
  <p><img src="https://i.stack.imgur.com/TkkR8.png" alt="SellerName property"></p>
  
  <p>This is my code:</p>
  
  <pre><code>var db = new DBDataContext();
  
  Seller seller;
  if(!db.GetTable&lt;Seller&gt;().Any(s =&gt; s.Username == username))
  {
      seller = new Seller {Username = username, SellerName = name, FeedbackCount = feedback};
      db.Sellers.InsertOnSubmit(seller);
      db.SubmitChanges();
  }
  </code></pre>
  
  <p>This is what I want to insert as an name: <code>Bâ™¥Râ™</code></p>
  
  <p>And This is the generated SQL:</p>
  
  <pre><code>INSERT INTO [dbo].[Sellers]([Username], [SellerName], [FeedbackCount])
  VALUES (@p0, @p1, @p2)
  
  SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value]
  -- @p0: Input VarChar (Size = 8000; Prec = 0; Scale = 0) [testuser]
  -- @p1: Input NVarChar (Size = 4000; Prec = 0; Scale = 0) [Bâ™¥Râ™]
  -- @p2: Input Int (Size = -1; Prec = 0; Scale = 0) [886]
  -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 4.0.30319.17929
  </code></pre>