Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: open sqilite path unicode

by kcott (Abbot)
on Nov 02, 2013 at 09:24 UTC ( #1060916=note: print w/ replies, xml ) Need Help??


in reply to open sqilite path unicode

According to the DBD::SQLite documentation, the connect() syntax is (from the SYNOPSIS):

my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","");

You appear the missing the dbname= part.

I'd suggest you use the utf8 pragma and hard-code the connect() call, with the unicode character(s), directly into your script (or, at least, a test version); e.g.

my $dbh = DBI->connect('dbi:SQLite:dbname=C:\folder-', ...);

Remove all the Tk and SQL code: just attempt to connect to the database. Work on getting that happening. If you encounter difficulties, ask here but include all relevant details (see the "How do I post a question effectively?" guidelines if you're unsure about this step).

Once you have a script that allows you to successfully connect(), start adding the other parts back in a bit at a time.

Repeat the process outlined: fixing small problems as they occur or asking here when you can't. Eventually, you'll have everything fixed — and may still retain much of your original hair :-)

-- Ken


Comment on Re: open sqilite path unicode
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (8)
As of 2014-11-26 01:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (160 votes), past polls