php display ISO-8859-1 latin1_swedish_ci chatacter such as ìíóò from Mysql

[phppaper]

Dear all,

 

my mysql database has a field latin1_swedish_ci and contain characters such as  ìíóò

 

my page is in UTF8 and could not display the chararters  ìíóò (appear as other thing)

 

Is there any php function could make this work? PS.: the field latin1_swedish_ci cannot change and the page utf8 cannot change.

 

thanks

[btherl]

You could try using this: http://au.php.net/manual/en/function.mb-convert-encoding.php

 

Or, mysql probably has some built-in functions to convert encoding.  I am guessing you need to convert from latin1 (aka iso-8859-1)  to utf8.