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]
and monks are getting baked in the sun...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2018-07-21 13:46 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (449 votes). Check out past polls.