FrontAccounting forum — non-ascii encoding (currencies etc)

Re: non-ascii encoding (currencies etc)

2010-10-29T14:29:20Z

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)

2010-09-13T02:17:09Z

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)

2010-08-19T13:43:12Z

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)

2010-08-19T10:45:36Z

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)

2010-08-19T09:06:58Z

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)

2010-08-19T08:18:28Z

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