FrontAccounting forum — £ sign in currency

Re: £ sign in currency

null@example.com (dvarsani) — Fri, 14 Mar 2014 15:32:28 +0000

After executing update query on sqlyog, I see this "Â£" as current symbol.

Thanks

Re: £ sign in currency

null@example.com (apmuthu) — Thu, 13 Mar 2014 16:18:46 +0000

The insert statement in many CoA sql sets including the default show "?" for "£". Try to use some hex editor or a special character aware text editor like Notepad++ to edit the sql files before use.

Also using a MySQL client like SQLyog (they have a free community edition) will get the job done.

Re: £ sign in currency

null@example.com (dvarsani) — Thu, 13 Mar 2014 11:17:38 +0000

Currency symbol column is VARCHAR(10), Character set id utf8 and collation is utf8_general_ci. System is accepting $ sign. On using € sign, the system doesn't throw an error. The symbol remains "?"

I am using mysql version 5.6.16

Thanks

Re: £ sign in currency

null@example.com (apmuthu) — Thu, 13 Mar 2014 07:48:41 +0000

What is the default collation and charset for your db / table / fields specifically the curr_symbol field?

INSERT INTO `0_currencies`(`currency`,`curr_abrev`,`curr_symbol`,`country`,`hundreds_name`,`auto_update`,`inactive`) VALUES ('Pounds','GBP','£','England','Pence',1,0);

UPDATE `0_currencies SET currency='Pounds', curr_symbol='£', country='England', hundreds_name='Pence' WHERE curr_abbrev='GBP';

The above code may appear same as yours but for the character set in question it may be binarily different. Hope you have utf-8 collation.

£ sign in currency

null@example.com (dvarsani) — Wed, 12 Mar 2014 23:57:54 +0000

I am getting this error when I insert "£" in Currency Symbol field

DATABASE ERROR :
At file C:\www\fa\gl\includes\db\gl_db_currencies.inc:23:
could not update currency for GBP
error code : 1366
error message : Incorrect string value: '\xA3' for column 'curr_symbol' at row 1
sql that failed was : UPDATE 0_currencies SET currency='Pounds', curr_symbol='£', country='England', hundreds_name='Pence',auto_update = '1' WHERE curr_abrev = 'GBP'

Thanks