By anupam on

Hi,
I created the .PO files for an Indian language and was up and running with my site. A day later, all the articles turned into glibrish and I'm not able to see the original language. Interestingly I can see the proper characters when I type and preview them (in the forum module). But when they show up in a block or when I try to read them, they turn into glibrish.
If anyone has any idea whats going on and how to solve it, I would very much appreciate it.
Thanks,
Anupam.

PS. The site is http://www.aryasamaj.org/newsite (note that the translation seems to be OK but the articles are not)

⋅ Categories: Drupal 4.7.x

Comments

anupam’s picture

anupam commented

This is what I found in the log file, if anyone can give me a pointer about what this means, that would be great. Thanks.

details
Type php
Date Wednesday, August 9, 2006 - 08:18
User anupam
Location http://www.aryasamaj.org/newsite/?q=comment/reply/3
Referrer http://www.aryasamaj.org/newsite/?q=comment/reply/3
Message Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT COUNT(cid) FROM comments WHERE pid = 0 AND nid = 3 AND subject = 'Adding Hindi Comment: ????????' AND comment = '????\r\n\r\n???????????' in /home/aryasama/public_html/newsite/includes/database.mysql.inc on line 120.
Severity error
Hostname 151.203.254.59

anupam’s picture

anupam commented

I fixed the error by changing the locale in the tables from latin1_...._ci to utf8_general_ci.

I have no clue why this was working the first day or what modified the DB to make it not work.