mysql> show create table data;
+-------+-----------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                      |
+-------+-----------------------------------------------------+
| data  | CREATE TABLE `data` (
  `id` int(11) NOT NULL auto_increment,
  `key` varchar(255) default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 | 
+-------+-----------------------------------------------------+
1 row in set (0.00 sec)

#!/usr/bin/env perl
# Core Modules
use strict;
use warnings;
use utf8;
use open ':encoding(UTF-8)';
use open ':std';

# CPAN Modules
use DBI;

# Options
my $host     = 'localhost';
my $database = 'test';
my $user     = 'root';
my $passwd   = '';
my $options  = { RaiseError => 1, AutoCommit => 1, mysql_enable_utf8 => 1 };
my $dsn      = "dbi:mysql:database=$database";

# connect to database
my $dbh = DBI->connect($dsn, $user, $passwd, $options);

# insert statement
my $insert_sql = q{
    INSERT INTO data SET
    `key`   = ?,
    `value` = ?
};
my $insert = $dbh->prepare($insert_sql);

# read all statement
my $select_sql = q{
    SELECT `id`, `key`, `value`
    FROM   data
};
my $select = $dbh->prepare($select_sql);


# input some data
$insert->execute('näme',  'dävid');
$insert->execute('wörld', 'föö');
$insert->execute('möp',   'müps');

# print all inserted
$select->execute();
while ( my $data = $select->fetchrow_arrayref() ) {
    printf "id: %d key: %s value: %s\n", @$data;
}

sidburn@sid:~/perl$ ./db.pl 
id: 1 key: näme value: dävid
id: 2 key: wörld value: föö
id: 3 key: möp value: müps

mysql> SET NAMES utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM data;
+----+--------+--------+
| id | key    | value  |
+----+--------+--------+
|  1 | näme  | dävid | 
|  2 | wörld | föö  | 
|  3 | möp   | müps  | 
+----+--------+--------+
3 rows in set (0.00 sec)