Re^9: UTF8 issue when getting website via LWP::UserAgent in Perl

Ah you little beauty - that did it! It still shows up buggered in phpmyadmin:

view here

...but when going in/out of the DB, it now seems to output it correctly :) The weird thing, is that if I look at the data from that table using the CMS's own admin panel (where you can view the data) ... then it looks fine! It just seems to be phpmyadmin that has it confused now.

Thanks :)

Andy

Comment on Re^9: UTF8 issue when getting website via LWP::UserAgent in Perl

Replies are listed 'Best First'.
Re^10: UTF8 issue when getting website via LWP::UserAgent in Perl by hippo (Archbishop) on May 12, 2016 at 16:12 UTC
It just seems to be phpmyadmin that has it confused now. Yet another reason (if one were needed) to avoid that particular "utility".	[reply]
Re^11: UTF8 issue when getting website via LWP::UserAgent in Perl by ultranerds (Hermit) on May 12, 2016 at 16:20 UTC
haha - and what would you suggest using instead? Its a nice system as a GUI, especially when trying to get new tables / columns etc setup quick ;)	[reply]