WatchPart Posted May 5, 2007 Share Posted May 5, 2007 Hello all. When i woke up this morning i checked my site and the £ symbol has been replaced with a ? symbol any ideas? Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2007 Share Posted May 5, 2007 Hello all. When i woke up this morning i checked my site and the £ symbol has been replaced with a ? symbol any ideas? No, it should not happen unless someone else has access. Link to comment Share on other sites More sharing options...
WatchPart Posted May 5, 2007 Author Share Posted May 5, 2007 No, it should not happen unless someone else has access. Yeah i can understand that, three people have access to the shop but insist on not touching anything. Any suggestions where i can find the change? Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2007 Share Posted May 5, 2007 Yeah i can understand that, three people have access to the shop but insist on not touching anything. Any suggestions where i can find the change? admin/currencies/ukpound or whatever you call it. Highlight, press edit and copy £ from this post and paste where it says symbol left. Link to comment Share on other sites More sharing options...
WatchPart Posted May 5, 2007 Author Share Posted May 5, 2007 admin/currencies/ukpound or whatever you call it. Highlight, press edit and copy £ from this post and paste where it says symbol left. Yeah have already tried that spoken to one of the guys who have access they said they updated the currencies before bed.... might be something else :'( Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2007 Share Posted May 5, 2007 Yeah have already tried that spoken to one of the guys who have access they said they updated the currencies before bed.... might be something else :'( Updating the currencies would not do it. So the £ symbol shows where I said to put it? Link to comment Share on other sites More sharing options...
WatchPart Posted May 5, 2007 Author Share Posted May 5, 2007 Updating the currencies would not do it. So the £ symbol shows where I said to put it? Yeah Every thing is fine I have even checked it with one of our other stores Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2007 Share Posted May 5, 2007 Yeah Every thing is fine I have even checked it with one of our other stores It is very strange and beyond my expertise. It seems like the ? is hard coded somewhere. Link to comment Share on other sites More sharing options...
WatchPart Posted May 5, 2007 Author Share Posted May 5, 2007 character encoding has some thing to do with this as i have tested it in my browser and everything is fine. Then it goes back to ? Link to comment Share on other sites More sharing options...
WatchPart Posted May 22, 2007 Author Share Posted May 22, 2007 Im still lost on this topic. Can anybody else suggest anything Link to comment Share on other sites More sharing options...
radders Posted May 23, 2007 Share Posted May 23, 2007 So what character encoding are you using in mySQl? Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2007 Share Posted May 23, 2007 Hi WatchPart, This is problem has surfaced quite a lot in the past. I managed to find a simple workaround saving a fresh install.... Copy this ₤ and paste it as a replacement symbol. Its not that elegant, I know, but it will save you from loosing sleep 'till some genius here locates this bug! Hope this helps David Link to comment Share on other sites More sharing options...
timpea Posted May 23, 2007 Share Posted May 23, 2007 Hi, I had a problem with £ not being shown on one of our sites, to solve it i changed the CharSet in the english.php languages file around line 45: to be // charset for web pages and emails define('CHARSET', 'UTF-8'); See if that helps you. Tim Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2007 Share Posted May 23, 2007 Hello Timpea, Didn't work for me. Has anyone here found another solution? Link to comment Share on other sites More sharing options...
♥Vger Posted May 23, 2007 Share Posted May 23, 2007 If it was working one day and not working the next then the host upgraded MySQL or PHP overnight and it/they now use utf-8 as the default encoding, where previously they used en-iso8859-1 or Latin 1 (same thing) as the encoding. That would cause the £ sign to become question marks. It's not as simple as just changing the pound sign in the osCommerce admin panel, because all orders in the orders_total field in the database will have a ? instead fo £ sign. Yo'll need to run an sql command something like this: UPDATE orders_total SET '?' = '£'; Vger Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.