Select Code to Download

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

...
           AutoCommit => 1,
           sqlite_string_mode => DBD_SQLITE_STRING_MODE_UNICODE_STRICT
          });

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

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