• Alban
  • New member
  • Offline
  • Registered: 08/19/2010
  • Posts: 2

Topic: non-ascii encoding (currencies etc)

Hello,

I installed frontaccounting, I checked that the tables in the database are all utf8_unicode_ci collations, but it seems things are not encoded as UTF-8. For example I cannot see the proper Euro character, nor can I create a Chinese currency with ¥ symbol.
Also, if I type some Chinese characters, in Company name for example, it's transformed to &something; characters.
I think to remember I tried frontaccounting long ago and it was working... did I do something wrong this time ? How to fix it ?
By the way, I used the en_US-new.sql schema. Is it related ?

Thanks for all,

Alban

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: non-ascii encoding (currencies etc)

Hi,

Try to run the System Diagnostics in the Setup tab. It will mostly tell if something is missing, charset or so.

/Joe

  • Alban
  • New member
  • Offline
  • Registered: 08/19/2010
  • Posts: 2

Re: non-ascii encoding (currencies etc)

mmh, not sure if it's related but I have this :

Language configuration consistency     Required     en_GB     Ok

Should I change it to something else ?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: non-ascii encoding (currencies etc)

No, I guess not. Perhaps there are somebody out there that have a little more knowledge about this than us smile

/Joe

  • From: Indonesia, Jakarta
  • Registered: 02/08/2010
  • Posts: 17

Re: non-ascii encoding (currencies etc)

Dear all,
I also encountered the same problem. but I think this is because the table 0_currencies not use UTF-8, then I turned it into UTF-8. it's fixed. so please change the table (0_currencies) into UTF-8

Ary Wibowo
  • thhui
  • Senior Member
  • Offline
  • From: Hong Kong
  • Registered: 05/20/2009
  • Posts: 63

Re: non-ascii encoding (currencies etc)

Yes. The default encoding of the field is not utf-8.
Pls change it yourself.

Or could joe make a script to change the db table structure easily?