Beefy Boxes and Bandwidth Generously Provided by pair Networks Frank
There's more than one way to do things
 
PerlMonks  

Re^2: UTF8 driving me up the wall again!

by ultranerds (Pilgrim)
on Sep 04, 2012 at 12:44 UTC ( #991613=note: print w/ replies, xml ) Need Help??


in reply to Re: UTF8 driving me up the wall again!
in thread UTF8 driving me up the wall again!

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


Comment on Re^2: UTF8 driving me up the wall again!
Select or Download Code
Re^3: UTF8 driving me up the wall again!
by remiah (Hermit) on Sep 04, 2012 at 13:22 UTC

    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

        No, I don't mean you are double encoding.

        When I see *this page*, my firefox says it is Windows-1252 encoding. It is in View menu -> Character Encoding -> Checked encoding in the list. IE has same kind of option

        So, what does your browser think it's encoding when you see your troubled phpmyadmin page? Doesn't she think it is iso-8859-1 even thought it is UTF-8?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (6)
As of 2014-04-21 06:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (491 votes), past polls