Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: open sqilite path unicode

by ig (Vicar)
on Nov 02, 2013 at 21:17 UTC ( #1060979=note: print w/replies, xml ) Need Help??

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, it works...I'm confused

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1060979]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2023-06-06 08:56 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (26 votes). Check out past polls.