Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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!
Re^2: UTF8 driving me up the wall again!
by ultranerds (Pilgrim) on Sep 04, 2012 at 12:51 UTC
    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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2014-07-13 02:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (245 votes), past polls