Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: open sqilite path unicode

by ig (Vicar)
on Nov 02, 2013 at 21:17 UTC ( [id://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, NTFS...ad it works...I'm confused

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (4)
As of 2024-03-28 17:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found