title: Add emoji / emoticon to SQL Server table
body: <p>I am trying to insert emoji / emoticons to a SQL Server database but it just stores <code>???</code> instead of the emoji / emoticons.</p>
  <p>I am finding only help for SQL Server not MySQL.</p>
  <p>I tried : <a href="https://stackoverflow.com/questions/7814293/how-to-insert-utf-8-mb4-characteremoji-in-ios5-in-mysql/8109948#8109948">link</a></p>
  <p>but not finding answers even not able to set with :</p>
  <pre><code>ALTER TABLE mytable charset=utf8mb4, 
      MODIFY COLUMN textfield1 VARCHAR(255) CHARACTER SET utf8mb4,
      MODIFY COLUMN textfield2 VARCHAR(255) CHARACTER SET utf8mb4;
  </code></pre>
  <p>SQL Server does not recognize this command. This is only for Microsoft SQL Server not MySQL</p>