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

Cheers,
Ovid

Live and work anywhere in the world.

The official Perl 6 wiki.

Comment on Re: UTF8 driving me up the wall again!

Replies are listed 'Best First'.
Re^2: UTF8 driving me up the wall again! by ultranerds (Hermit) 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` [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	[reply] [d/l] [select]
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


Keep It Simple, Stupid
	PerlMonks