{"id":152,"date":"2012-12-23T21:53:33","date_gmt":"2012-12-24T05:53:33","guid":{"rendered":"http:\/\/www.bryonross.com\/blog\/?p=152"},"modified":"2012-12-23T21:53:33","modified_gmt":"2012-12-24T05:53:33","slug":"emoji-and-mysql","status":"publish","type":"post","link":"http:\/\/www.bryonross.com\/blog\/?p=152","title":{"rendered":"Emoji and MySQL"},"content":{"rendered":"<p>One of the great things about being a software developer is that I get to learn new and relatively useless information all the time. \u00a0Today, I learned about <a href=\"http:\/\/en.wikipedia.org\/wiki\/Emoji\">emoji<\/a>\u00a0or Japanese picture characters. \u00a0As far as I can tell, these characters allow users of many Japanese cell phones to text cute pictures like balloons and bowing businessmen to one another with ease and at minimal expense.<\/p>\n<p>One neat fact about emoji is that it falls outside of the <a href=\"http:\/\/en.wikipedia.org\/wiki\/Plane_(Unicode)#Basic_Multilingual_Plane\">basic multilingual plane<\/a> (BML), which means that it cannot be represented using three or fewer bytes in <a href=\"http:\/\/en.wikipedia.org\/wiki\/UTF-8\">UTF-8<\/a>\u00a0(a popular character encoding in modern software). Unfortunately, for historical reasons, <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/charset-unicode-utf8.html\">MySQL&#8217;s utf8 character set<\/a> can only represent characters within the BML. \u00a0That means that if you want Japanese cell phone users to be able to store balloon picture characters in your MySQL database, you can&#8217;t store that text as utf8 character data. \u00a0(Luckily, the folks on the MySQL team recognized this issue and added a new character set [<a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/charset-unicode-utf8mb4.html\">utf8mb4<\/a>]\u00a0capable of storing emoji and other characters outside the BML in version 5.5.3.)<\/p>\n<p>If you&#8217;re on a Japanese cell phone, here&#8217;s a balloon:\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the great things about being a software developer is that I get to learn new and relatively useless information all the time. \u00a0Today, I learned about emoji\u00a0or Japanese picture characters. \u00a0As far as I can tell, these characters allow users of many Japanese cell phones to text cute pictures like balloons and bowing [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=152"}],"version-history":[{"count":1,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":153,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions\/153"}],"wp:attachment":[{"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bryonross.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}