Running hippo's test on Windows 10: 
\test>perl test-unicode-sqlite.pl
1..14
ok 1 - Creating database a/databaseTest1.db
ok 2 - Created table data
ok 3 - Disconnected from a/databaseTest1.db
ok 4 - Database file exists
ok 5 - Reconnected to database a/databaseTest1.db
ok 6 - Results set obtained from a/databaseTest1.db
ok 7 - Disconnected from a/databaseTest1.db
ok 8 - Creating database ⁿ/databaseTest2.db
ok 9 - Created table data
ok 10 - Disconnected from ⁿ/databaseTest2.db
not ok 11 - Database file exists
#   Failed test 'Database file exists'
#   at test-unicode-sqlite.pl line 22.
ok 12 - Reconnected to database ⁿ/databaseTest2.db
ok 13 - Results set obtained from ⁿ/databaseTest2.db
ok 14 - Disconnected from ⁿ/databaseTest2.db
# Looks like you failed 1 test of 14.

test>dir  ü
 Volume in drive C is Win10
 Volume Serial Number is D27E-5B7F

 Directory of ...test\ü

11/08/2017  09:36 AM    <DIR>          .
11/08/2017  09:36 AM    <DIR>          ..
11/08/2017  09:36 AM             2,048 databaseTest2.db
               1 File(s)          2,048 bytes
               2 Dir(s)  813,772,779,520 bytes free

[download]
So - this looks like a perl filesystem api issue, but hippo's code is able to reconnect.

                All power corrupts, but we need electricity.

In reply to Re: Connect SQLite with unicode directory by NetWallah
in thread Connect SQLite with unicode directory by IB2017

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.