my $dbh = DBI->connect(
        'DBI:mysql:db_main',
        'user',
        'pass',
        {
            RaiseError        => 1,
            AutoCommit        => 1,
            mysql_enable_utf8 => 1,
            on_connect_do => [ "SET NAMES 'utf8'", "SET CHARACTER SET 'utf8'" ]
        }
    )