use DBD::SQLite::Constants ':dbd_sqlite_string_mode';

my $dbh = DBI->connect( "dbi:SQLite:dbname=:memory:", "", "",
          {RaiseError => 1,
           AutoCommit => 1,
           sqlite_string_mode => DBD_SQLITE_STRING_MODE_UNICODE_STRICT
          });

##</code><code>##

my $utf8_text1 = "\N{LATIN CAPITAL LETTER A WITH RING ABOVE}ke Lindstr\N{LATIN SMALL LETTER O WITH DIAERESIS}m";

##</code><code>##

my $insert = $dbh->prepare('INSERT INTO names VALUES(?, ?)');
$insert->execute('nm0512537', $utf8_text1);