Trying to fix some foreign characters

[c_shelswell]

Hi I seem to have had a small problem with my mysql database a while back (i think when i switched from windows to linux) Anyway it seems to have replaced all my 'é' with 'é' (it also shows as '�')i was trying to do an ereg_replace on them like:

 

        //username input = 'Andr�'

        $username = $row['username'];
$pattern = '/é/';
$replacement = '/é/';
$fixedNames = eregi_replace($pattern, $replacement, $username);

 

This however seems to do absolutely nothing. Does anyone have any ideas how i might go about sorting this problem?

 

Many thanks