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? 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? 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! 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? 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 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. 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 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. Link to comment https://forums.phpfreaks.com/topic/142758-squares-squares-everywhere/#findComment-749560 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.