title: primary key INT for emoji
body: <p>I am writing a MySQL table to store data about every single emoji:</p>
  
  <pre><code>CREATE TABLE `emoji` (
      `emoji_id` INT(10) UNSIGNED NOT NULL,
      `name` VARCHAR(255) NOT NULL,
      `html` VARCHAR(255) NOT NULL,
      PRIMARY KEY (`emoji_id`)
  );
  </code></pre>
  
  <p>An example insertion might be:</p>
  
  <pre><code>INSERT INTO `emoji` VALUES (12345, 'grinning face', '&amp;#x1F600;');
  </code></pre>
  
  <p>Or:</p>
  
  <pre><code>INSERT INTO `emoji` VALUES (67890, 'woman walking', '&amp;#x1F6B6;&amp;#x200D;&amp;#x2640;&amp;#xFE0F;');
  </code></pre>
  
  <p>However, instead of my own proprietary ID number <code>12345</code> or <code>567890</code>, I would like to use a universal decimal number that is already assigned to each emoji.</p>
  
  <p>Does such an ID number exist?</p>
  
  <p>I thought about simply converting the hexadecimal representation to decimal to use as the <code>emoji_id</code> primary key, however this does not work because some emoji (such as my second example) are represented by a sequence of hexadecimal numbers.</p>