• From: UK
  • Registered: 10/02/2012
  • Posts: 146

Topic: £ sign in currency

Hi

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: £ sign in currency

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);

or

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.

apmuthu's Website

  • From: UK
  • Registered: 10/02/2012
  • Posts: 146

Re: £ sign in currency

Hi

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: £ sign in currency

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.

apmuthu's Website

  • From: UK
  • Registered: 10/02/2012
  • Posts: 146

Re: £ sign in currency

Hi

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

Thanks