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? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment 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.