hotmert Posted June 25, 2011 Share Posted June 25, 2011 All I did was inset a field to my database, and now, all my price symbols ie £ have been replaced by �. It was fine before so why has it changed, and what can I do to stop it happening again grrrrrr! Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/ Share on other sites More sharing options...
Nuv Posted June 25, 2011 Share Posted June 25, 2011 Which field did you inser?t to the database ? Can you tell us more about the problem ? Can you post relevant code ? Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234622 Share on other sites More sharing options...
gristoi Posted June 25, 2011 Share Posted June 25, 2011 It will be because the field I you are writing to in your database is being written to in iso-8859-1 format. If you are using any kind of special characters in your fields then you need to ensure you use utf-8 Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234624 Share on other sites More sharing options...
hotmert Posted June 25, 2011 Author Share Posted June 25, 2011 SQL database with 'id', 'date', 'event', 'bands', 'info', 'price'. Server side I added 'pic' after 'info'. New data added to the database comes out ok but what was already in there the price symbol has changed to the black diamond. I have tried deleting the 'price' field content for one record, saving the re-writing the price server side and through my form but no change?? This is the out put page, if you look, choose jun http://www.thefiddlerselbow.co.uk/gig_guide.php No changes have been made to the charset...like I said it worked before, so why not now. I have looked at the charset for utf-8 and i have a lot of choices in the list but they all have an option after ie utf-8-general, utf-8-universal, utf-8-russian etc...no english there. Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234626 Share on other sites More sharing options...
hotmert Posted June 25, 2011 Author Share Posted June 25, 2011 In IE comes up as a hollow square Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234629 Share on other sites More sharing options...
hotmert Posted June 25, 2011 Author Share Posted June 25, 2011 This is the database snapshot [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234631 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.