JoomFish showing question marks instead of text in japanese and tajik languages

728 views Asked by At

Today when I opened my website I saw question marks instead of texts. Question Marks are showing in japanese and tajik languages. The strange is that inside database it is also ?(Marks). Does anyone know what is the problem? I have Joomla 1.5 and JoomFish for translating website language. Question marks are shown on all japanese characters. In Tajik language only in some characters are being shown ? marks. My website is navrasta.com

1

There are 1 answers

5
Ilie Pandia On

I have had the exact same problem with a JoomFish installation on Joomla 1.5.

From time to time some of the articles would contain just question marks ("?")

Those articles would be lost and I would have to recover them from backups.

What solved the problem for me was to change the database to have my tables use the charset "uft8" and the collation of "uft8_general_ci". Previously I had "latin1_general_ci"

Please backup your database before you attempt to do this.

You should change the charset and collation for at least these tables:

  • "jos_content" - your articles are stored here in the default language
  • "jos_jf_content" - your translation are stored here.

(of course you need to replace 'jos_' with your actual table prefix)

Good luck and always do backups before altering the database!