Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

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
Node Status?
node history
Node Type: note [id://1060979]
[ambrus]: As for TeX, I'm not trying to discourage anyone from writing carefully beautifully typeset documents, in maths or outside. But most people aren't willing to do that, and will spend only little time about the formatting,
[ambrus]: and try to leave everything else to automated systems without checking how what they write came out format-wise, and for those people, discounting the part about journals with a specific format above,
[ambrus]: just blindly recommending to use LaTeX is a bad idea now.
[Discipulus]: I havery limited needs in such field. Sometimes (for children party invitations) i draw something by hand and I scan it to include into an ms doc.

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2017-09-26 11:22 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (293 votes). Check out past polls.