http://qs321.pair.com?node_id=1060979


in reply to open sqilite path unicode

I created a SQLite database in C:\folder-ü and ran your sample program and it opened the database successfully. I tried another directory with other non-ASCII characters in the name and had no trouble opening a database in that directory either. This with 64bit Strawberry Perl 5.16.2 on 64bit Windows 7 Professional.

What version of perl are you running and what is your operating system?

Replies are listed 'Best First'.
Re^2: open sqilite path unicode
by Anonymous Monk on Nov 03, 2013 at 12:18 UTC

    Hello, I'm running ActiveState 5.16

    Here is the simple code I'm working on right now with some (maybe) useful error messages. The database is in a folder containing a "ü" in its name...

    use strict; use warnings; use UTF8; use Tk; use DBD::SQLite; use Data::Dumper; $Data::Dumper::Useqq=1; my $mw = new MainWindow; my $types = [ ['Text', '.db'], ['All Files', '*'],]; my $file_1= $mw->getOpenFile(-filetypes => $types); #just looking at how the path is print Dumper($file_1); #connecting to sqlite my $dbh = DBI->connect("dbi:SQLite:$file_1", "", "", { RaiseError => 1 +, AutoCommit => 1, PrintError => 0 });

    ... connection error

      What file system are you using there? NTFS or one of the FAT versions? (I know about PHP having issues with NTFS and non-ASCII characters)

      And, perhaps you could diagnose what readdir returns as name of the concerned folder...

        I'm working on a Windows 8 machine (64bit), NTFS: not working. Just tried the same script, same database, same ActiveState on a Windows 7 machine, NTFS...ad it works...I'm confused