TOPIC: Language error help

We were able to resolve this- you were right- it was in the database- while parts were set correctly, we found that some were not. Now that it is all in the utf8 the comments are working. I also uninstalled it and reinstalled it. Between the two- it is now working. Yea!

nice
In 99% of the cases wrong database collation is the problem of everything!

as a newbie to the php database- I had to go carefully- but learned something new.
Thanks

Daniel,
I am also seeing the same issue. My visitors were posting comment in "Hindi" language and all I see is "??????". After reading this thread, I checked the jos_comment table and it was latin_swedish..." something.. So I changed the collation of the table to "utf8_general_ci" but I still see the same "?????" in the comments..

here is the URL..

informationmadness.com/cms/index.php?opt...ent_id=5629#josc5629

All my tables need to be "utf8_general_ci" ??

Thank you.

I think at least all t he jos_comment tables need to be changed to this "utf8_general_ci". Make sure that all the admin settings in joomla component for jos_comment are also set for your language. These steps worked for the Arabic. Other's here know more than I do- but these are my thoughts.

All tables and fields in the tables need to be utf8_general_ci

Ok I checked the table fields and they were set to "latin1_swedish_ci"..even though the table collation is "utf8-general-ci"..

I have installed JoomaMyAdmin.. how to change all the table and fields to "utf8_general_ci" ??

Thank you.

Got it working. I changed the jos_comments table to utf8_general_ci but the fields were still "latin1_swedish.." so I change the fields to "utf8_general_ci" and now its working fine.

Thank you guys.

Hello.
I have a problem with the romanian special character like ăîşţ . when I post a comment it shows ? character instead of the romanian special characters.
Also I have seen that in DEMO website you have the same problem.
Can you please tell me how to solve it ?

Regards.

hm the demo site has the same problem? I'll check it. Read what the other guys wrote and you will solve the problem.

Thank's Daniel. The problem with the Demo on the site is probably with the charset wich is not set on UTF-8 and it's in latin .
I solved my issue. The problem was that I did not made the modification on the proper table . So , as you said , the problem was from CHARSET witch was "latin"...
regards.

P.S. congrats on the comment extend...