Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

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.

Comment on Re: UTF8 driving me up the wall again!
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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2015-10-09 22:34 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (253 votes), past polls