phppaper Posted April 19, 2011 Share Posted April 19, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/234121-php-display-iso-8859-1-latin1_swedish_ci-chatacter-such-as-%C3%AC%C3%AD%C3%B3%C3%B2-from-mysql/ Share on other sites More sharing options...
btherl Posted April 19, 2011 Share Posted April 19, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/234121-php-display-iso-8859-1-latin1_swedish_ci-chatacter-such-as-%C3%AC%C3%AD%C3%B3%C3%B2-from-mysql/#findComment-1203339 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.