Select Code to Download

Select or download this

746572e280a62ee280... becomes
746572c3a2c280c2a6...

Select or download this
for(keys %$row){utf8::decode($row->{$_}) if utf8::is_utf8($row->{$_})}

Select or download this

CREATE TABLE `host_MyApp_DUFs` (
  `DUF_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) unsigned NOT NULL COMMENT '',
...
  KEY `DUF_id` (`DUF_id`)
) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8 COLLATE=utf8_u
+nicode_ci COMMENT='';
/*!40101 SET character_set_client = @saved_cs_client */;

Select or download this

    my $dbix = DBIx::Lite-> connect( 
        "dbi:mysql:dbname=$ENV{DB_NAME}",
        $ENV{DB_USER},
        $ENV{DB_PASSWORD},
        { mysql_enable_utf8 => 1 }
    );

Select or download this

  DB<6> x $st->fetchrow
0  'character_set_client'
...
                                                                      
+                                                                     
+                     DB<13> x $st->fetchrow
0  'character_sets_dir'
1  '/usr/share/mysql/charsets/'

Select or download this

746572e280a62ee280... becomes
746572c3a2c280c2a6...