Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: UTF8 driving me up the wall again!

by Ovid (Cardinal)
on Sep 04, 2012 at 11:03 UTC ( #991596=note: print w/ replies, xml ) Need Help??


in reply to UTF8 driving me up the wall again!

I'm not entirely certain what's happening here as there are a few missing pieces of the puzzle. Is your table's encoding set as UTF-8? Also, when you say "the output of your script is OK", do you mean the Data::Dumper output? And have done a SELECT directly against the database table to see if the data is being store in the format you're expecting?

If you want to understand more about handling Unicode, my book is temporarily online for free and Chapter 9 contains a Unicode section which, while incomplete (it would take an entire book of its own), does explain the basics of Perl's Unicode handling well enough for you to debug most problems.


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:44 UTC
    Hi,

    Thanks for the reply. By "every where else", I literally mean that :)

    What I see in the admin panel for this script:

    ID 75322 edit delete Name Fumigación Aérea Subcategory of Agricultura

    ..and in the interface for viewing the records: (user interface)

    Fumigación Aérea

    And a similar system to phpmyadmin (called mySQLMan):

    75300     Fumigación Aérea     75299     75299     1     Agricultura/Fumigación Aérea      

    The only place the accents are not working is in phpmyadmin :(

    I'm just trying to get user setup so I can access it from a local hosted GUI interface for mySQL (HeidiSQL)... I'll post once I've managed to do a test with that

    TIA

    Andy

      When you see utf-8 string 'Fumigación Aérea' with iso-8859-1 encoding, you will see this

      Fumigación Aérea
      So, I guess if you change browser's encoding to UTF-8 manually, you will see what you want.

      So, check PHPMyAdmin's configuration. You will see "misc" menu at right side of menus, there will be "variables" pull down entry. At that entry, You will see configuration key, value pairs. What is "character set ***" values?

      I am sorry for my lack of knowledge how to set these values, I am not good at mysql.

        Thanks for the reply. The weird thing, is that FF *is* in utf-8 for the encoding... if I change to iso-8859-1 then it double encodes :/

        I'm just uploading a fresh copy of phpmyadmin to see if that helps

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (7)
As of 2014-09-23 09:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (216 votes), past polls