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]
[karlgoethebier]: shmem: scheiss technik
[karlgoethebier]: shmem: yes - i f you manage it to get on the bike. and pray if you must stop...
[shmem]: in the french alpes, at the end of a gravel road, we had a beer at a hut - and heard an enduro coming up.
[shmem]: not by the road, but from there below where you wouldn't want to walk.
[shmem]: the biker stopped the machine at the table and took off his helmet.
[shmem]: long white hair, long beard the same, then he proceeded to get off the bike
[shmem]: saying "biking itself isn't that much, but getting up and down - hell!"

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2017-06-25 20:08 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (570 votes). Check out past polls.