FrontAccounting forum — non-ascii encoding (currencies etc)

Re: non-ascii encoding (currencies etc)

null@example.com (thhui) — Fri, 29 Oct 2010 14:29:20 +0000

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?

Re: non-ascii encoding (currencies etc)

null@example.com (nucreativa) — Mon, 13 Sep 2010 02:17:09 +0000

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

Re: non-ascii encoding (currencies etc)

null@example.com (joe) — Thu, 19 Aug 2010 13:43:12 +0000

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

/Joe

Re: non-ascii encoding (currencies etc)

null@example.com (Alban) — Thu, 19 Aug 2010 10:45:36 +0000

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 ?

Re: non-ascii encoding (currencies etc)

null@example.com (joe) — Thu, 19 Aug 2010 09:06:58 +0000

Hi,

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

/Joe

non-ascii encoding (currencies etc)

null@example.com (Alban) — Thu, 19 Aug 2010 08:18:28 +0000

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