title: is SQLite representing unicode as an american flag
body: <p>In a Rails app, I have the following unicode characters within a row in a column of type: text</p>
  
  <pre><code>\U0001F64F\U0001F1FA\U0001F1F8- 
  </code></pre>
  
  <p>When I output this in the rails console by calling the module name: Module.find(id).text</p>
  
  <p>It prints it as a small American flag:</p>
  
  <p><img src="https://i.stack.imgur.com/Iqkst.png" alt="enter image description here"></p>
  
  <p>Can anyone explain what's happening here? I've read that SQLite uses UTF-8 and UTF-16 for encoding text but I'm not sure if this is due to SQLite or is it something else.</p>