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

[ultranerds]

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

[remiah]

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.

[ultranerds]

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

[remiah]

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?