Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^3: Need tipps for identifying utf-8 problems with Dancer and MySQL

by McA (Curate)
on Jun 17, 2014 at 18:38 UTC ( #1090190=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Need tipps for identifying utf-8 problems with Dancer and MySQL
in thread Need tipps for identifying utf-8 problems with Dancer and MySQL

Hi,

First of all I don't know sqlite3. There are some players in the game: sqlite3 and DBD::xxx. When the DBD driver for sqlite you use does not decode the byte strings which come from the sqlite database, than you have to do it.

use Encode qw(decode); my $decoded_string = decode('UTF-8', $byte_string_from_sqlite);

Which driver 'DBD::xxx' are you using?

UPDATE: Have a look at http://search.cpan.org/~ishigaki/DBD-SQLite/lib/DBD/SQLite.pm#DRIVER_PRIVATE_ATTRIBUTES. I'm pretty sure that is what you are looking for: sqlite_unicode

Regards
McA


Comment on Re^3: Need tipps for identifying utf-8 problems with Dancer and MySQL
Download Code
Re^4: Need tipps for identifying utf-8 problems with Dancer and MySQL
by kwetal (Initiate) on Jun 18, 2014 at 13:45 UTC
    $dbh->{sqlite_unicode} = 1;

    Well yes! That's exactly the answer to my problem. Thank you very much.

    That explains why I couldn't find it in perldoc DBD; clearly I was browsing the wrong doc.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2014-08-31 04:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls