Weird Characters in messages

[Senkusha]

Hi all!  I finally got around to fixing this issue on my boards.....once a long time ago, I had Western Encoding, but then changed over to UTF (since I needed to read/write in Japanese characters).  As a result, I got strange little characters in my posts that drove me nuts.

Well, today I found the answer.  This may not be a complete fix, but it sure looks like it got most of it!

Open a query window in phpMyAdmin or whatever and paste the following queries:

Code Select Expand


update smf_messages
set body = replace(body,'’','\'');

update smf_messages
set body = replace(body,'…','...');

update smf_messages
set body = replace(body,'â€"','-');

update smf_messages
set body = replace(body,'“','"');

update smf_messages
set body = replace(body,'”','"');

update smf_messages
set body = replace(body,'‘','\'');

update smf_messages
set body = replace(body,'•','-');

update smf_messages
set body = replace(body,'‡','c');

update smf_messages
set body = replace(body,'Â',' ');


It might also help to run the following using the smf_members table on the signature field too, but after a quick check I haven't seen any that need adjustment.

[greyknight17]

Thanks for posting what you found. There have been other users with similar problems with their languages. Don't recall how they solved it, but this can come in handy.

Topic marked as solved since there is no question here

[Realinfo]

when I try this in phpmyadmin, Then I got this message

"You have to choose at least one column to display"

[Arantor]

1. Are you using SMF 1.x?
2. Why are you bumping a 4 year old topic?
3. You're supposed to put that into the SQL tab, not the normal query tab.

[Realinfo]

1. Are you using SMF 1.x?
2. Why are you bumping a 4 year old topic?
3. You're supposed to put that into the SQL tab, not the normal query tab.

1. 2.0.4
2. as I have same issue ( and it's really big problem for me)
3. Yes, I got sloution by ur third point.

[Realinfo]

But I still have some Weird Characters in messages

ÃÆ'Æ'à ¢Ã¢â€š ¬Ã, ¦ÃƒÆ'ââ,¬Å¡Ãƒâ€šÃ, ¡ÃƒÆ'Æ'Æââ,¬â,,¢ÃƒÆ'ââ,¬  à ¢Ã¢â€š ¬Ã¢â€ž ¢ÃƒÆ'Æ'ÂÃ, ¢ÃƒÆ'Ã, ¢Ãƒ ¢Ã¢â€š ¬Ã


how to replace them

please see there some http://realinfo.tv/index.php?topic=2.0

[Arantor]

1. 2.0.4

So why are you not opening a new topic in the right place?

2. as I have same issue

So why are you not opening a new topic in the right place?

[Realinfo]

1. 2.0.4

So why are you not opening a new topic in the right place?

2. as I have same issue

So why are you not opening a new topic in the right place?

1.,2. As This issue is not related to version of SMF, It's issue of mysql and thanks to Arantor & Senkusha for sloving a big issue for me.




I tried this

Code Select Expand

update smf_messages
set body = replace(body,'Ã','');

update smf_messages
set body = replace(body,'ƒ','');

update smf_messages
set body = replace(body,'š','');

update smf_messages
set body = replace(body,'€','');


update smf_messages
set body = replace(body,'€™',''');

update smf_messages
set body = replace(body,'¦','');


update smf_messages
set body = replace(body,'œ','"');


update smf_messages
set body = replace(body,'â','');

update smf_messages
set body = replace(body,'Â','');


update smf_messages
set body = replace(body,'Æ','');

update smf_messages
set body = replace(body,'†','');

update smf_messages
set body = replace(body,'™','');

update smf_messages
set body = replace(body,'Å','');

update smf_messages
set body = replace(body,'¬','');

update smf_messages
set body = replace(body,'¡','');

update smf_messages
set body = replace(body,'ž','');

update smf_messages
set body = replace(body,'§','');

update smf_messages
set body = replace(body,'¼','');

update smf_messages
set body = replace(body,'½','');

update smf_messages
set body = replace(body,'¾','');

update smf_messages
set body = replace(body,'¶','');

update smf_messages
set body = replace(body,'³','');

update smf_messages
set body = replace(body,'½','');



Now Please guide one more thing

I have these wierd characters in Topic Subjects also, please tell how to replace them

[Arantor]

1.,2. As This issue is not related to version of SMF, It's issue of mysql and thanks to Arantor & Senkusha for sloving a big issue for me.

How do you know that's the case? It might be. It STILL might be. But hey, you know best of course, because posting in the right board as opposed to a 4 year old solved topic (that the entire support team are ignoring) is definitely the way to go.

And since you know best, you clearly don't need my help.

[Realinfo]

1.,2. As This issue is not related to version of SMF, It's issue of mysql and thanks to Arantor & Senkusha for sloving a big issue for me.

How do you know that's the case? It might be. It STILL might be. But hey, you know best of course, because posting in the right board as opposed to a 4 year old solved topic (that the entire support team are ignoring) is definitely the way to go.

And since you know best, you clearly don't need my help.

I Guess there is need to move this topic in right board.
and
I still need ur help................

Now Please guide just one more thing

I have these wierd characters in Topic Subjects also, please tell how to replace them

[Realinfo]

I have these wierd characters in Topic Subjects also, please tell how to replace them

is this code is ok

update smf_topics
set body = replace(body,'€','');

[mashby]

Please start your own topic. This one is marked solved.