mdgeus Posted November 25, 2010 Share Posted November 25, 2010 Hi, I have setup a new server with PHP & MySQL on IIS6 / win 2003. after copying the first website and database I'm having this issue with the output generated on the new server. new server: Server version: 5.1.53-community Protocol version: 10 old server: Server version: 5.0.67-community-nt Protocol version: 10 One entry in the old server is TREVIÑO and this is copied to the new server as TREVIÑO (I've used the synchronize option in phpmyadmin 3.3. I'm using some string manipulation to make it look better. -- ucwords(mb_strtolower(substr($string, 0,25), 'UTF-8')) -- the output is on the old server: Treviño (what it should be) and on the new server: Treviãƒâ€˜o (which is exactly how it is in the database) Can somebody tell me where to look for this problem? Link to comment https://forums.phpfreaks.com/topic/219812-migrating-to-new-server/ Share on other sites More sharing options...
mdgeus Posted November 25, 2010 Author Share Posted November 25, 2010 I just did the database copy again and now the text is the same in the old and the new database. The only problem is the output from PHP Link to comment https://forums.phpfreaks.com/topic/219812-migrating-to-new-server/#findComment-1139508 Share on other sites More sharing options...
mdgeus Posted November 26, 2010 Author Share Posted November 26, 2010 And, ofcourse after some searching I found the solution myself. mysql server was configured with default charset utf-8 which was the problem. setting it to latin1 solved it for me. Link to comment https://forums.phpfreaks.com/topic/219812-migrating-to-new-server/#findComment-1139858 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.