Re: UTF8 driving me up the wall again!

[Neighbour]

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.

[ultranerds]

Hi,

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 :)

Andy