Currency Symbols corrupted on confirmation e-mail

[MikeHunt79]

My shop was running great until we needed to upgrade our hosting package, and out hosting company did a backup of our server, and put it all on the new server.

 

Everything seemed to work fine, apart from the confirmation e-mails. The problem is the currency symbols. Our shop uses british sterling (?), us dollars ($) and euros (?).

 

Now, in the shop and th shop admin, the symbols look fine, but here is how it looks in the confirmation e-mail.

 

Here's what it looks on the e-mail like if the order is placed in british pounds (sterling):

 

GBP        1 x DVD title 2 () = £20.00

 

Euros:

 

Euros      1 x DVD title 1 () = €28.83

 

But dollars look ok.

 

What is causing this? I need to fix this as it's a live shop.

[mi_jaiten]

My shop was running great until we needed to upgrade our hosting package, and out hosting company did a backup of our server, and put it all on the new server.

 

Everything seemed to work fine, apart from the confirmation e-mails. The problem is the currency symbols. Our shop uses british sterling (?), us dollars ($) and euros (?).

 

Now, in the shop and th shop admin, the symbols look fine, but here is how it looks in the confirmation e-mail.

 

Here's what it looks on the e-mail like if the order is placed in british pounds (sterling):

Euros:

But dollars look ok.

 

What is causing this? I need to fix this as it's a live shop.

<{POST_SNAPBACK}>

Try deleting the symbols save and upload without symbols, then put the symbols back (use stock symbols say from e.g. Microsoft Word) then save and upload, if this doesn't solve the problem, as it is a live shop, remove the symbols and put the text equivalent i.e. GBP - USD - EU until you have the answer.

[MikeHunt79]

Hmm, I tried deleting and adding the symbols but it didn't make a difference. The symbols like fine in the shop, but not in the e-mail. I could use the currency suffixes you suggested, but I'd rather get the symbols working, as they used to work fine.

[fonopress]

Try deleting the symbols save and upload without symbols, then put the symbols back (use stock symbols say from e.g. Microsoft Word) then save and upload, if this doesn't solve the problem, as it is a live shop, remove the symbols and put the text equivalent i.e. GBP - USD - EU until you have the answer.

<{POST_SNAPBACK}>

 

Hello there is this the only solution to these corrupted currency codes in e-mail?

Maybe some has another solution!

 

Wojciech

[spiritquest]

Hello there is this the only solution to these corrupted currency codes in e-mail?

Maybe some has another solution!

 

Wojciech

 

This is an annoying bug, which must have something to do with the character set translation, or a bug/error with the function.

 

I have had these problems, especially with Shipping Modules. Adjusting the text files, to have price information does not display properly if I simply put '?' in the text. I get the same error as was mentioned at the beginning of this thread £ - I am struggling with the Batch Print Module to not have this show on the Invoices, and there seems to be no trade off.

 

I can either fix it for the store by using £ instead of '?', but then it won't work on the batch print center, as the translation ruins it. So how do I get around this .. php htmlspecialchars() function ? Any bods out there that can give me any advice on this please.

 

Cheers.

[spiritquest]

Hello there is this the only solution to these corrupted currency codes in e-mail?

Maybe some has another solution!

 

Wojciech

 

Hello there is this the only solution to these corrupted currency codes in e-mail?

Maybe some has another solution!

 

Wojciech

 

This is an annoying bug, which must have something to do with the character set translation, or a bug/error with the function.

 

I have had these problems, especially with Shipping Modules. Adjusting the text files, to have price information does not display properly if I simply put '?' in the text. I get the same error as was mentioned at the beginning of this thread £ - I am struggling with the Batch Print Module to not have this show on the Invoices, and there seems to be no trade off.

 

I can either fix it for the store by using £ instead of '?', but then it won't work on the batch print center, as the translation ruins it. So how do I get around this .. php htmlspecialchars() function ? Any bods out there that can give me any advice on this please. It seems that the British Pound symbol does not translate neatly, it does when called through osc's symbol stored in the database, not sure how to access that through the language files, maybe using the sprintf feature ?

 

Cheers.

[♥Vger]

My guess is that the answer to all of the problems posted here is in what language set MySQL is using on your server. Contact your hosting companies, explain the problem, and get them to fix it.

 

Vger

[spiritquest]

My guess is that the answer to all of the problems posted here is in what language set MySQL is using on your server. Contact your hosting companies, explain the problem, and get them to fix it.

 

Vger

 

 

Hi Rhea,

 

Thanks for your Input. But I'm not sure thats the fix, its not a mySQL problem (I don't think) - And my problem is currently set on my local machine.

 

As an example of this, if you go to php.net and type in '?' in the search box, you will see a result that it was searching for: £

 

So I think this is a php issue - and maybe to do with the character set being used by php.

 

I think ... not sure how it could be related to mySQL - Currently the character set I'm using in mySQL is Western Latin1

 

I don't know how this is related to the way php / oscomm utilise language sets.

 

Thanks.

[spiritquest]

Hi Rhea,

 

Thanks for your Input. But I'm not sure thats the fix, its not a mySQL problem (I don't think) - And my problem is currently set on my local machine.

 

As an example of this, if you go to php.net and type in '?' in the search box, you will see a result that it was searching for: £

 

So I think this is a php issue - and maybe to do with the character set being used by php.

 

I think ... not sure how it could be related to mySQL - Currently the character set I'm using in mySQL is Western Latin1

 

I don't know how this is related to the way php / oscomm utilise language sets.

 

Thanks.

 

There seems to be a sync issue with character sets used by the admin and shop side of the store. You have to make sure that both english.php files in admin and the catalog folder are set correctly to the same character set, then go into the adminstration area and update your chosen currency symbol. This then, I think, stores the data in the table using the given character set chosen. I think my problems arose when having a mixture of utf-8 and iso-8859-1 between the two areas. My test server setup is different to the production server.

 

I tried a series of configurations to come up with this solution, by placing test orders, after changing the character set and testing the results by reviewing the orders_totals table, which physically writes the currency symbol into a column.

 

Hope this comes to some use. Ideally I would like to use utf-8 across the board, but I am not sure it will work as there seems to be some confusion , I may need to wait until my production server has mysql 4.1 installed as this allows you to create utf-8 tables.