Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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

by Anonymous Monk
on May 05, 2014 at 11:07 UTC ( #1085036=note: print w/ replies, xml ) Need Help??


in reply to Need tipps for identifying utf-8 problems with Dancer and MySQL

How are you letting DBI know to decode these strings as UTF8?


Comment on Re: Need tipps for identifying utf-8 problems with Dancer and MySQL
Re^2: Need tipps for identifying utf-8 problems with Dancer and MySQL
by Skeeve (Vicar) on May 05, 2014 at 11:40 UTC

    The fun thing about Dancer is: You do not need to take care. At least that's my impression.


    s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
    +.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e

      The fun thing about Dancer is: You do not need to take care. At least that's my impression.

      Sounds like wishful thinking

        Nope, it is Perl's "Do What I Mean" magic.

        But seriously, in the docs of Dancer::Plugin::Database I read:

        AUTOMATIC UTF-8 SUPPORT
        As of version 1.20, if your application is configured to use UTF-8 (you've defined the charset setting in your app config as UTF-8) then support for UTF-8 for the database connection will be enabled, if we know how to do so for the database driver in use. If you do not want this behaviour, set auto_utf8 to a false value when providing the connection details.
        So indeed don't do anything other than enabling UTF-8 in your configuration and don't mess around with setting UTF-8 yourself.

        DWIMMERY at its best.

        CountZero

        A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

        My blog: Imperial Deltronics

Log In?
Username:
Password:

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

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

    The best computer themed movie is:











    Results (158 votes), past polls