bladechob Posted January 28, 2009 Share Posted January 28, 2009 I've just migrated a rather large database to a new server and all seems to be ok except for one niggling thing. Wherever a £ sign is shown on the php front end it mutates into a small square. None of the calculations or pages seem to be affected - just this irritating square thing. Is this a unicode issue or something? Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/ Share on other sites More sharing options...
fenway Posted January 28, 2009 Share Posted January 28, 2009 Maybe... are you talking about the actual DB values or PHP output? Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-748583 Share on other sites More sharing options...
bladechob Posted January 28, 2009 Author Share Posted January 28, 2009 php output I changed AddDefaultCharset UTF8 to AddDefaultCharset ISO-8859-1 but still seeinf squares! Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-748605 Share on other sites More sharing options...
fenway Posted January 28, 2009 Share Posted January 28, 2009 Is this a UTF8 field? Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-748624 Share on other sites More sharing options...
bladechob Posted January 28, 2009 Author Share Posted January 28, 2009 all the php pages on the site and their html dependents are set to ISO - ther server however was originally set at utf - the config has been changed to iso now. Excuse spelling as the batteries in my keyboard are about to die Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-748632 Share on other sites More sharing options...
fenway Posted January 29, 2009 Share Posted January 29, 2009 that doesn't answer the question. Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-749383 Share on other sites More sharing options...
bladechob Posted January 29, 2009 Author Share Posted January 29, 2009 nope it isn't Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-749398 Share on other sites More sharing options...
fenway Posted January 29, 2009 Share Posted January 29, 2009 Well, I'm done. Confirm that the data is fine in the database, make sure you're db connection and your php script are set properly. Otherwise, maybe someone else can decipher it. Quote Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-749560 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.