1 Topic by asgare (edited by asgare 06/08/2016 08:22:38 am)

  • asgare
  • asgare
  • Senior Member
  • Offline
  • From: Iran
  • Registered: 06/03/2013
  • Posts: 92

Topic: FA 2.4RC1--Do not retrieve DB data in UTF

For using FA, I fully modified DB (including all default values, languages and chart of accounts) to localize both language and chart of account.
I always had problem viewing DB information in FA, even after changing DB in utf-8.
In previous versions I solved this issue via adding 

 mysql_set_charset("utf8");

within two functions in connect_db.inc file and this way I could solve it.

Nevertheless in FA 2.4 there are major updates and I don't know how do I solve this.

Thanks to all FA contributors smile
Asghar
  • asgare
  • asgare
  • Senior Member
  • Offline
  • From: Iran
  • Registered: 06/03/2013
  • Posts: 92

Re: FA 2.4RC1--Do not retrieve DB data in UTF

I solved this

Changed SET NAMES latin1; to UTF8

Thanks to all FA contributors smile
Asghar
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: FA 2.4RC1--Do not retrieve DB data in UTF

In the Charts itself?

apmuthu's Website

  • asgare
  • asgare
  • Senior Member
  • Offline
  • From: Iran
  • Registered: 06/03/2013
  • Posts: 92

Re: FA 2.4RC1--Do not retrieve DB data in UTF

at the beginning of DB. All tables charset were settled utf8 previously but I don't know why and from were this statement didn't change.

Also in previous versions DB does not had this statement.

Thanks to all FA contributors smile
Asghar