phpMyAdmin

I have a web aplication than run with MySQL 3.xx and edit with PMA in utf8 ok.

My Hosting upgrade MySQL to 4.1.13 a the phpMyAdmin is 2.6.4-pl2 charset is utf8 and collation is utf8_spanish_ci

When insert a register from webform show in web browser ok but if I edit in phpMyAdmin the character (áé´úñ) show like Ñú view image http://ninaiz.com/pma.png

And if insert a register with PMA show in web Browser with bad characters . View image http://ninaiz.com/web.png

I am going crazy with this.

Thank you very much and sorry for my English is very difficult for me the explication.

The solution:

After the DB connection:

@mysql_select_db($db_name,$enlace) or die(mysql_error());

Add this line:

@mysql_query("SET NAMES 'utf8'");

This is a code modification for your application?

Good design!
[url=http://sbtdizjt.com/xnbr/nyuw.html]My homepage[/url] | [url=http://ttcdmpun.com/vzyu/oles.html]Cool site[/url]

Great work!
[url=http://flrebdfm.com/lrxo/hzqr.html]My homepage[/url] | [url=http://wsmcgjth.com/tcpu/baep.html]Cool site[/url]

Nice site!
<a href="http://sbtdizjt.com/xnbr/nyuw.html">My homepage</a> | <a href="http://izbmschi.com/uqnf/oqik.html">Please visit</a>

Nice site!
<a href="http://flrebdfm.com/lrxo/hzqr.html">My homepage</a> | <a href="http://pbcvvcvs.com/mocj/inoe.html">Please visit</a>

Nice site!
http://sbtdizjt.com/xnbr/nyuw.html | http://tzzzjrjb.com/mvxk/viov.html

Thank you!
http://flrebdfm.com/lrxo/hzqr.html | http://kvohzoxn.com/obrc/aiel.html