TOPIC: problems with charater display

After I posted thai language messege in long text I get "?" symbol , pls visit url below for this case

www.lcdsure.com/index.php?option=com_content&view=article&id=57

I've try to figured this out for a fews days but it make me more confuse because it will display right character in Name and Title box but wrong character in Text box.

my sql is UTF-8

I'm sorry to disturb you but many people from my country have problems about !joomlacomment like me.

hi can you guide us on how you managed to fix this issue, I have the same problem

I have the same problem.
The charset in mysql (in phpmyadmin) are displayed correctly.
They also displayed correctly in admin comment edit mode.
but not in admin comment display or on web page.

my charset is utf8_general_ci.

I think Ive found a solution for this.
goto phpmyadmin
then look through the charset of the needed tables make sure that they are switched to utf8, the .sql file that comes with the component is not a utf8 sql insertion.

All the tables are utf8_general_ci like I said above. And the characters are displayed correctly in phpmyadmin.
I think it must be in a script but still can't find it.

And now when I try to lookup comments in administration screen the server crashes (on my testing server).
I use joomla 1.5.3 php 5.1.4 mysql 5.0.22

I still get funny characters in my production server.
There are many different utf-8 charset. I tried utf8_unicode_ci , Which would be best?

I've disabled the AJAX support , and not include javascript library nothing changes. (the comment settings still work)

I've written a short test script using php to fetch data from jos_comment and display on screen. The words are all perfect no funny characters at all. So it must be in the script somewhere. Probably java script.

I've been looking and testing in components>>com_comment nothing changes.

Can anyone tell what to do?

Per default joomla 1.5 uses utf8_general_ci.
Which version of joomla are you using?

I use joomla 1.5.3 php 5.1.4 mysql 5.0.22

I also use legacy 1.0 because I am using a mambo template

what is the chosen charset in joomlacomment?

I have the same problem.
The charset in mysql (in phpmyadmin) are displayed correctly.
They also displayed correctly in admin comment edit mode.
but not in admin comment display or on web page.

my charset is utf8_general_ci.

Anyone can answer?

Hello Mr Daniel Dimitrov .

The same problem with polish characters in comments.

Whole joomla site charset is utf-8
MySQL on utf also
Joomlacomment charset utf-8

The site and all components shows right polish characters but joomlacomment not.

Problem Solved!

In mysql joomlacomment tables latin1_swedish_ci was set as a 'character comparision method'. The setting was present just after installing a component so it's strange. By reading forum I know situation with latin1_swedish_ci is common. But why?

I replaced every instance of latin1_swedish_ci by utf_general_ci and it's OK.

Is this helping everyone?

rxdani wrote:

Problem Solved!

I replaced every instance of latin1_swedish_ci by utf_general_ci and it's OK.

My character set was already utf8_general_ci in the first place

jshadow can you make a test for me. Go to the backend the security->overflow

and change the values there to something big.
for example for line length -1 and so on.
Are there any changes to the output or is still the problem there?

OK that worked!!!
Thanks Daniel.

I tried a few combination of settings. Only by setting

Line max length: -1
Word max length: -1

will it work.

As with Post max length:
I had to increase it to 2000 from 1000 originally.

Thanks again

JShadow you don't have anymore the character encoding problem?

No, it is correct now.

Ok, then we know where the problem is coming from.
I will have a look on the functions that are making the lines.