Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: open sqilite path unicode

by kcott (Chancellor)
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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1060916]
[planetscape]: boo

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2017-10-23 03:45 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (276 votes). Check out past polls.