Re^2: 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
[download]

..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

Replies are listed 'Best First'.
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` [download] 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.	[reply] [d/l]
Re^4: UTF8 driving me up the wall again! by ultranerds (Hermit) on Sep 04, 2012 at 13:57 UTC
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	[reply]
Re^5: UTF8 driving me up the wall again! by remiah (Hermit) on Sep 04, 2012 at 21:16 UTC
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?	[reply]