document.write('<link rel="stylesheet" href="http://gist.github.com/stylesheets/gist/embed.css"/>')





document.write('<div id=\"gist-228455\" class=\"gist\">\n  \n  \n    \n            \n\n      <div class=\"gist-file\">\n        <div class=\"gist-data gist-syntax\">\n          \n          \n          \n            <div class=\"gist-highlight\"><pre><div class=\"line\" id=\"LC1\"><span class=\"nb\">require<\/span> <span class=\"s1\">&#39;mysql&#39;<\/span><\/div><div class=\"line\" id=\"LC2\">&nbsp;<\/div><div class=\"line\" id=\"LC3\"><span class=\"k\">class<\/span> <span class=\"nc\">Mysql<\/span><span class=\"o\">::<\/span><span class=\"no\">Result<\/span><\/div><div class=\"line\" id=\"LC4\">&nbsp;&nbsp;<span class=\"k\">def<\/span> <span class=\"nf\">encode<\/span><span class=\"p\">(<\/span><span class=\"n\">value<\/span><span class=\"p\">,<\/span> <span class=\"n\">encoding<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">&quot;utf-8&quot;<\/span><span class=\"p\">)<\/span><\/div><div class=\"line\" id=\"LC5\">&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nb\">String<\/span> <span class=\"o\">===<\/span> <span class=\"n\">value<\/span> <span class=\"p\">?<\/span> <span class=\"n\">value<\/span><span class=\"o\">.<\/span><span class=\"n\">force_encoding<\/span><span class=\"p\">(<\/span><span class=\"n\">encoding<\/span><span class=\"p\">)<\/span> <span class=\"p\">:<\/span> <span class=\"n\">value<\/span><\/div><div class=\"line\" id=\"LC6\">&nbsp;&nbsp;<span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC7\">&nbsp;&nbsp;<\/div><div class=\"line\" id=\"LC8\">&nbsp;&nbsp;<span class=\"k\">def<\/span> <span class=\"nf\">each_utf8<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">block<\/span><span class=\"p\">)<\/span><\/div><div class=\"line\" id=\"LC9\">&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"n\">each_orig<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">row<\/span><span class=\"o\">|<\/span><\/div><div class=\"line\" id=\"LC10\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"k\">yield<\/span> <span class=\"n\">row<\/span><span class=\"o\">.<\/span><span class=\"n\">map<\/span> <span class=\"p\">{<\/span><span class=\"o\">|<\/span><span class=\"n\">col<\/span><span class=\"o\">|<\/span> <span class=\"n\">encode<\/span><span class=\"p\">(<\/span><span class=\"n\">col<\/span><span class=\"p\">)<\/span> <span class=\"p\">}<\/span><\/div><div class=\"line\" id=\"LC11\">&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC12\">&nbsp;&nbsp;<span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC13\">&nbsp;&nbsp;<span class=\"k\">alias<\/span> <span class=\"n\">each_orig<\/span> <span class=\"n\">each<\/span><\/div><div class=\"line\" id=\"LC14\">&nbsp;&nbsp;<span class=\"k\">alias<\/span> <span class=\"n\">each<\/span> <span class=\"n\">each_utf8<\/span><\/div><div class=\"line\" id=\"LC15\">&nbsp;<\/div><div class=\"line\" id=\"LC16\">&nbsp;&nbsp;<span class=\"k\">def<\/span> <span class=\"nf\">each_hash_utf8<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">block<\/span><span class=\"p\">)<\/span><\/div><div class=\"line\" id=\"LC17\">&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"n\">each_hash_orig<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">row<\/span><span class=\"o\">|<\/span><\/div><div class=\"line\" id=\"LC18\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"n\">row<\/span><span class=\"o\">.<\/span><span class=\"n\">each<\/span> <span class=\"p\">{<\/span><span class=\"o\">|<\/span><span class=\"n\">k<\/span><span class=\"p\">,<\/span> <span class=\"n\">v<\/span><span class=\"o\">|<\/span> <span class=\"n\">row<\/span><span class=\"o\">[<\/span><span class=\"n\">k<\/span><span class=\"o\">]<\/span> <span class=\"o\">=<\/span> <span class=\"n\">encode<\/span><span class=\"p\">(<\/span><span class=\"n\">v<\/span><span class=\"p\">)<\/span> <span class=\"p\">}<\/span><\/div><div class=\"line\" id=\"LC19\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"k\">yield<\/span><span class=\"p\">(<\/span><span class=\"n\">row<\/span><span class=\"p\">)<\/span><\/div><div class=\"line\" id=\"LC20\">&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC21\">&nbsp;&nbsp;<span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC22\">&nbsp;&nbsp;<span class=\"k\">alias<\/span> <span class=\"n\">each_hash_orig<\/span> <span class=\"n\">each_hash<\/span><\/div><div class=\"line\" id=\"LC23\">&nbsp;&nbsp;<span class=\"k\">alias<\/span> <span class=\"n\">each_hash<\/span> <span class=\"n\">each_hash_utf8<\/span><\/div><div class=\"line\" id=\"LC24\"><span class=\"k\">end<\/span><\/div><div class=\"line\" id=\"LC25\">&nbsp;<\/div><\/pre><\/div>\n          \n        <\/div>\n\n        <div class=\"gist-meta\">\n          <a href=\"http://gist.github.com/raw/228455/2b973e20addd0ef2b96910b999a7059e4105f263/mysql_utf8.rb\" style=\"float:right;\">view raw<\/a>\n          <a href=\"http://gist.github.com/228455#file_mysql_utf8.rb\" style=\"float:right;margin-right:10px;color:#666\">mysql_utf8.rb<\/a>\n          <a href=\"http://gist.github.com/228455\">This Gist<\/a> brought to you by <a href=\"http://github.com\">GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n  \n<\/div>\n')
