Joomla Forum

if the topic name has double quotes in it, for example:

This is a topic that will end up in the "Guinness book of records"

it displays in the module:

This is a topic that will end up in the "Guinness book of records""

Anybody else having this problem or knows why it happens?

Cheers,
NiCo

Guys...

Isn´t there anybody there that is using text in any language that has special characters or accented letters like spanish, german, french, etc... that can confirm that they are or are not properly being displayed in mod_recenttopics 2.0?

Cheers,
NiCo

im having same issue, some characters such as İ (I with a dot), ç,Ç are shown as &quot etc.

what charset are you using in your template. This or somthing else?

What Collation do you have in your database UTF-8 or somthing else

Livebox:

Thanks for your help  :)

In mod_smfrecenttopics is the only place in my site where these characters are not being properly displayed.

This is what i have in my joomla template´s index.php:


Replacing that with the Utf line you mentioned doesn´t solve the issue.

Concerning the database, if i look with MySQLFront at the database properties, i see that Character Set is "latin1", while nothing is selected in the "Collation" list. If i change the Character set from "latin1" to "utf8" nothing seems to change :-(

Cheers,
NiCo

just Check MySQL.net for more info how to do this

You have to do this for the database the tabels and fields

Livebox:

could you be so kind as to give me a little bit more info on why i need this change in all my database, tables and fields?

Thanks a lot,
NiCo

You can find this info on Simplemachines.org ;)

some extra info
Convert both data and database tables to UTF-8 character set (do this also with your Joomla database, for beter intergration)

Syntax

void ConvertUtf8 ()

Notes

    * requires the admin_forum permission.
    * uses the convert_utf8 sub template of the Admin template.
    * only works if UTF-8 is not the global character set.
    * supports all character sets used by SMF's language files.
    * redirects to ?action=maintain after finishing.
    * is linked from the maintenance screen (if applicable).
    * accessed by ?action=convertutf8.

Livebox:

I don´t think you are helping me much by just suggesting that i make a massive change in my Joomla and SMF database, without explaining why this is needed, and now pointing me just to the definition of a function of the SMF API, which happens to be a function that is already used inside the SMF code, making your suggestion even more confusing.

Please can you be a little bit more ellaborate on what you know, if you are sure that you have the solution to my problem?

thank you  :)
NiCo

P.D: Nobody else is using a language with accented letter or umlauts, such as Spanish, French, Scandinavian languages, etc...? Nobody else is having my problem?  ::)

I might be able to add something like htmlspecialchars to the string from SMF, but it should alreayd be in this format.  I'll take a look.

I gave you two options one for the template the other to check your SQL. an I pointed you to the Simplemachines forum. It is not on me That you not read this on that site ;) There is a lot writen on the SMF board

http://docs.simplemachines.org/index.php?topic=865

ok...i see it now  ;)

Unfortunately, as per the document, this change doesn´t apply to me, because both of the languages i offer in my site are of the same character set: Spanish and English are both ISO-8859-1

So that means my problem comes from something else.

Thanks anyway,
NiCo

have you tried different browsers/settings in same browser?

Both IE and Firefox display the same.

I just observed a VERY important detail that i should have observed earlier  :-[ : Spanish especial letters like á, é, í, ó, ú and ñ display correctly

The problem seems to occur only when the Topic title has quotes in it. Not a quote is displayed but " is displayed

Cheers,
NiCo

I have the same problem

ok, shouldn't have to do this, but try this fix in mod_smf_recenttopics.php(in modules/):

on or around line 275 find this code

replace with



And then on or around line 284 find this code

and replace with


Let me know if that solves the problem.

Yes, it does solve the issue  ;)

will that make it to whenever a new version of the module is released?

Thanks,
NiCo

yes, Ill commit the changes tonight and upload it to the remository.

I have the same problem too.

I have tried this!!
But it's not working for Tranditional Chinese (UTF-8).
Any suggestions?

Same problem here with the update version of the module.. The changes you suggest are in place and still it doesnt show correct UTF-8 characters

I should say that both db and website are in utf8. It just shows question marks!!!!

Edit:
Forgot to mention the language is greek. The rest of the site is working perfect.

Because the erroneus characters appeared from the discussbot i also made a new post manually. The same result!

I have that problem too and that code doesn't solve utf-8 characters.

My site is in utf-8 completely, too.

However in previous version of my site i used mambo and orstio's software and that was solved with this hard-coding:

mysql_select_db($mosConfig_db);
mysql_query( "SET CHARSET 'utf8'" );
$sql = "SELECT id FROM ".$mosConfig_dbprefix."menu WHERE link='index.php?option=com_smf'";

SET CHARSET is the key to the solution.  But where to put it?

I'm having the same problem using German characters and would be happy if someomne could solve this problem. Characters like Ä Ü Ö etc. are not getting displayed properly.