Can not use (pound symbol) as currency symbol or in titles

[david@…]

I tried to change the currency symbol from a dollar ($) to a pound (£) one in the configuration section but when I hit update the field is still blank and nothing is displayed next to any price information on other parts of the site.

Also, if I use a pound symbol in other parts of the site, ie for the title of a note, it truncates the title at this point (for example, if my note title is 'received cheque for £10.00 today' it is saved as 'received cheque for ').

[brieb]

I was not able to recreate this problem.

It is quite possible that you are running an old version of mySQL or a versiont that does not support the SET NAMES feature to set the encoding type. phpBMS uses utf8 encoding, and mysql needs to also talk utf8 (the exception is PDFs, since fpdf does not like utf8, it utilizes the "latin1" encoding. Can you confirm your MySQL version?

[david@…]

My MySQL server information is as follows:

Server version: 5.0.32-Debian_7etch1-log
MySQL client version: 5.0.32
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

[brieb]

I am lost on this one. I cannot get the error to repeat on my end at all. Can we get a confirmation of these sympotms?

[david@…]

I just tried manually adding the £ symbol in to the settings table in the currency_symbol row, when I then viewed the orders/invoices page the £ symbol was displayed but was prefixed with an Â, so it looked like £10.00 for example.

It could be a issue with my particular web host in this case as I think lots of people would have mentioned this if it was a common occurrence. There is no mention specifically about this in the forums either, only one mention of a similar problem in the following post:

viewtopic.php?t=164 (sorry could not post full link)

I will ask my web hosting provider about this and see if they have any suggestions, if they do I will let you know.

[brieb]

The  problem should be fixed with changeset [294].

So it looks like the configuration page is not updating correctly. Can you update other settings? Can you set that setting back to a US dollar sign successfully?

[david@…]

It is only the pound symbol that does not get stored, the dollar sign and all other settings get stored and updated fine.

I have installed phpBMS on my home test server (Debian linux testing, PHP5, MySQL5) and it all works fine so I think it must be an issue with my web host's version/setup of MySQL.