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! Quote 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 ? Quote 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 Quote 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. Quote 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 Quote 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] Quote Link to comment https://forums.phpfreaks.com/topic/240352-black-diamonds/#findComment-1234631 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.