1 Topic by dedode (edited by dedode 08/22/2013 11:44:35 pm)

  • Registered: 08/22/2013
  • Posts: 14

Topic: [SOLVED] Problem with language after make a RESTORE!

Hi

I am a newbie in using FA 2.3.17.

After I make a restore I noticed that all my entries in my ARABIC language appeared as ????? ???.

So, what is the problem? and, how may I solve it?


regards.

Adel

2 Reply by dedode (edited by dedode 08/22/2013 11:45:36 pm)

  • Registered: 08/22/2013
  • Posts: 14

Re: [SOLVED] Problem with language after make a RESTORE!

Finally, I solve it after a long googling search and many trial&error.

Just follow next steps:

In the file /usr/share/phpmyadmin/libraries/dbi/mysqli.dbi.lib.php at the end of function PMA_DBI_connect() just before the return statement I added:

mysqli_query($link, "SET SESSION CHARACTER_SET_RESULTS =latin1;");
mysqli_query($link, "SET SESSION CHARACTER_SET_CLIENT =latin1;");




http://stackoverflow.com/a/4813043

regards.

Adel

  • Registered: 12/25/2007
  • Posts: 2,448

Re: [SOLVED] Problem with language after make a RESTORE!

Interesting. FrontAccounting does not use php mysqli extension...
Janusz

4 Reply by apmuthu (edited by apmuthu 09/04/2013 12:18:51 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: [SOLVED] Problem with language after make a RESTORE!

These can possibly be set up serverwide in the /etc/mysql/my.cnf file. It could also be a collation difference between the old mysql server and the new one for the character fields.

apmuthu's Website