FrontAccounting forum — FA table character set

Re: FA table character set

null@example.com (apmuthu) — Sun, 29 Sep 2013 18:03:50 +0000

can be latin1_unicode_ci too or latin_swedish_ci - but keep all the string fields and db collations the same.

Re: FA table character set

null@example.com (dvarsani) — Fri, 27 Sep 2013 13:43:57 +0000

Does the collation has to be latin1_general_ci?

Re: FA table character set

null@example.com (itronics) — Wed, 25 Sep 2013 11:07:49 +0000

Standard charset for all FA versions in 2.3 branch is latin1, so if you do not use any language requiring utf8, you should stay with latin1. Otherwise problems can arise in near future during upgrade to 2.4 which will use utf-8 entirely.
Janusz.

Re: FA table character set

null@example.com (apmuthu) — Wed, 25 Sep 2013 08:10:11 +0000

Make the database and tables latin1 and the columns default collation as latin1_general_ci or latin1_swedish_ci but it should be uniform throughout. Alternatively, make everything utf8 and collation utf8_general_ci which is the default recommended type.

It might be easier to take a backup of the sql, edit the sql and then restore it. The database collation and charset must be done outside of FA.

Re: FA table character set

null@example.com (dvarsani) — Tue, 24 Sep 2013 18:30:06 +0000

Yes I am using it for English only FA.

Sorry. The Collation are different for tables. It's "latin1_swedish_ci" and "utf8_general_ci" . The character is latin1 for colums where table collation is latin1_swedish_ci and utf8 where table collation is utf8_general_ci. Do I need to change my database. I am getting error when I post any documents with "£" sign in note or comment.

Re: FA table character set

null@example.com (apmuthu) — Tue, 24 Sep 2013 17:46:39 +0000

If you are using only english, then it may be okay but make sure the collation is the same for all string fields.

FA table character set

null@example.com (dvarsani) — Tue, 24 Sep 2013 16:54:31 +0000

In my frontaccounting database, some of my tables and columns have character set as "Latin1" and some are "utf8". Is this correct?