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

Re: UTF8 driving me up the wall again!

by Neighbour (Friar)
on Sep 04, 2012 at 11:20 UTC ( #991600=note: print w/replies, xml ) Need Help??

in reply to UTF8 driving me up the wall again!

There are lots of 'environments' that you could check for UTF8-compatibility:
  • Whatever console you are running your perl scripts from
  • The table-definition in your database
  • The connection to your database
  • phpmyadmin and everything related (webserver, php etc)
Some are trivial, others not so much :)

Does it work when you are inserting the data using phpmyadmin?
What about other mysql-clients...what do they show when retrieving the data?
What is shown when you query the data from the database using a perl script and dump it to (your UTF8-supporting) console?
Maybe phpmyadmin is borked.
Maybe your connection to mysql is not set to UTF8, which causes the mysql-driver to convert your UTF8-data to latin1 before it ends up in the database.
Maybe it's something else entirely.

Replies are listed 'Best First'.
Re^2: UTF8 driving me up the wall again!
by ultranerds (Friar) on Sep 04, 2012 at 12:51 UTC

    Mmm ok - its looking like a phpmyadmin issue :( I just added a test record from the admin panel, and its working fine. As soon as I try and edit it from phpmyadmin, for example "ábc ítest" then it comes up all broken when viewing the data... yet it works fine elsewhere. I'll get my host to take a look at phpmyadmin, as its looking like its a configuration error there somewhere (its a system resource, so I don't have access to edit the settings). I wish I'd realized this 3 hours ago - would have saved myself a lot of stress :s

    Thanks for the replies though guys :)


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://991600]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2018-06-21 22:57 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (120 votes). Check out past polls.