• Welcome to Simple Machines Community Forum. Please login or sign up.
December 03, 2021, 03:49:10 AM

News:

SMF 2.0.18 has been released! Please update. Read more.


Chinese and other special characters.

Started by nolefan, April 22, 2007, 11:29:58 AM

Previous topic - Next topic

nolefan


Hey folks...
I have a fresh install of SMF running with the lightning-dk theme by padexx ( http://raoulschinasaloon.com ).
Technically, SMF supports UTF-8 so if I type Chinese characters, they should show up... unfortunately, it's not the case. Which doesn't make sense ::) :(

Do I have to install the Chinese language pack before it can display Chinese characters?
I've done a search on the topic but none of the answers seemed to address my particular problem...

SleePy

Did you convert your forum to UTF-8?
Did you download the utf-8 language packs?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

nolefan

Quote from: SleePy on April 22, 2007, 11:40:23 PM
Did you convert your forum to UTF-8?
Did you download the utf-8 language packs?

I didn't read anything about converting the forum to UTF-8... I figured that was the default option. ... me confused...

SleePy

SMF supports UTF-8. But by default it is disabled.

This document should help explain more.
http://docs.simplemachines.org/index.php?topic=865.0
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

nolefan

Hey there,

thanks for all the help and I apologize profusely ahead of time for being such a nag but I just can't seem to get this taken care of.

The forum is in EnglishUTF-8, the DB is in English UTF8 and so is the theme. If I type something in French, chinese, japanese and preview it, there is no problem... then, if I press "post" it shows up as a question mark...
I've looked everywhere I could for an explanation, a fix and nothing... please please please...


Sarge

Read the "How to convert to UTF-8?" section in the document that SleePy gave you a link to.

Have you converted your forum with Admin > Forum Maintenance > Convert the database and data to UTF-8?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

nolefan

Quote from: Sarge on June 28, 2007, 07:43:21 AM
Read the "How to convert to UTF-8?" section in the document that SleePy gave you a link to.

Have you converted your forum with Admin > Forum Maintenance > Convert the database and data to UTF-8?

Hi Sarge,

I have read everything in the link SleePy gave me and spent loads of time in the admin section of my forum. I don't have anything in the forums maintenance that says " Convert Database and data to UTF-8".

the options I currently have are:
Optimize all tables to improve performance.
Check all files against current versions.
Find and repair any errors.
Recount all forum totals and statistics.
Empty out unimportant logs.
Convert HTML-entities to UTF-8 characters


SleePy

Did you try the default theme?
Not all themes support different character sets.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

nolefan

Quote from: SleePy on July 05, 2007, 01:29:05 PM
Did you try the default theme?
Not all themes support different character sets.

I did. The problem as I finally found out was that the DB itself was in latin_swedish_ci for whatever reason ( freaking Fantastico install!!!! ) and I'm working on changing it to utf8_general_ci.
SMF itself is installed in 8tf-8 so the whole thing is a bit messy...

Sarge

July 06, 2007, 01:20:34 AM #10 Last Edit: July 06, 2007, 01:31:43 AM by Sarge
Quote from: nolefan on June 29, 2007, 01:02:57 AM
Quote from: Sarge on June 28, 2007, 07:43:21 AM
Have you converted your forum with Admin > Forum Maintenance > "Convert the database and data to UTF-8"?

I don't have anything in the forums maintenance that says " Convert Database and data to UTF-8".

Have you tried deleting the entry global_character_set = UTF-8 in smf_settings and going to Admin > Forum Maintenance again? If you do that, the link I mentioned should appear.

Open phpMyAdmin (if you can access it for your hosted account), select your forum database and click on the SQL icon. It looks like this:



Enter the query (copy/paste from below) into the box and click the Go button.

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

The query above works if your forum tables prefix is smf_ (which is the default). You can find the exact prefix for your forum in Admin > Server Settings > Database Tables Prefix -- if it is different from smf_ then you have to modify the query before running it in phpMyAdmin.


[edit]
Also check the variables mentioned in this post:
http://www.simplemachines.org/community/index.php?topic=165442.msg1056581#msg1056581

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

nolefan

thank you , thank you , thank you, thank you!!!!!

it worked!

Sarge

Great! I'm so happy for you! :D

If you need assistance in the near future with the same issue, feel free to post in this topic again.

Enjoy. :)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

wtt

I also encountered the same problem. However, some sentences here are  too small. It is hard to read that. Just my 2 cents.
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

Sarge

Quote from: wtt on November 24, 2007, 10:01:26 AM
However, some sentences here are  too small. It is hard to read that.

You mean the font size?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

wtt

Hello Sarge, Yes, I meant the "Font Size"
"DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;" Is this statement right?

BTW, Are there step by step solution for this problem? I encountered the same problem here...

Quote from: Sarge on November 24, 2007, 06:35:10 PM
Quote from: wtt on November 24, 2007, 10:01:26 AM
However, some sentences here are  too small. It is hard to read that.

You mean the font size?
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

wtt

"Have you tried deleting the entry global_character_set = UTF-8 in smf_settings "
How can I do that?
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

wtt

"The problem as I finally found out was that the DB itself was in latin_swedish_ci for whatever reason ( freaking Fantastico install!!!! )" The same situation in my side. This seems to be a bug of Fantastico installation. I guess the guy who developed the software came from Latin countries... :)
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

wtt

How did you do that? I encountered the same problem, but I couldn't find the way to do that right now...

"I did. The problem as I finally found out was that the DB itself was in latin_swedish_ci for whatever reason ( freaking Fantastico install!!!! ) and I'm working on changing it to utf8_general_ci.
SMF itself is installed in 8tf-8 so the whole thing is a bit messy..."
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

Sarge

You don't have to post multiple times. If there's no reply after your last post, simply edit it.

Yes, it seems to be a Fantastico bug. It sets global_character_set as UTF-8 even if the tables are in latin1.

First, make a backup of your forum database. Then delete global_character_set from smf_settings (read reply #10 in this topic about how to do that). Then go to SMF Admin > Forum Maintenance and run "Convert the database and data to UTF-8?" -- SMF will convert the forum tables and set global_character_set to UTF-8.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

wtt

Hello Sarge, Thanks so much for your guide and I am sorry for my previous posts as I was a little bit freaking out. Anyway, any other folks would not encounter the same situation as me with your post here!

Quote from: Sarge on November 24, 2007, 10:26:19 PM
You don't have to post multiple times. If there's no reply after your last post, simply edit it.

Yes, it seems to be a Fantastico bug. It sets global_character_set as UTF-8 even if the tables are in latin1.

First, make a backup of your forum database. Then delete global_character_set from smf_settings (read reply #10 in this topic about how to do that). Then go to SMF Admin > Forum Maintenance and run "Convert the database and data to UTF-8?" -- SMF will convert the forum tables and set global_character_set to UTF-8.

Hello Sarge, I have done this to my database.
"DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;"
However, I found that it is not the solution for this problem.

Quote from: Sarge on July 06, 2007, 01:20:34 AM
Quote from: nolefan on June 29, 2007, 01:02:57 AM
Quote from: Sarge on June 28, 2007, 07:43:21 AM
Have you converted your forum with Admin > Forum Maintenance > "Convert the database and data to UTF-8"?

I don't have anything in the forums maintenance that says " Convert Database and data to UTF-8".

Have you tried deleting the entry global_character_set = UTF-8 in smf_settings and going to Admin > Forum Maintenance again? If you do that, the link I mentioned should appear.

Open phpMyAdmin (if you can access it for your hosted account), select your forum database and click on the SQL icon. It looks like this:



Enter the query (copy/paste from below) into the box and click the Go button.

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

The query above works if your forum tables prefix is smf_ (which is the default). You can find the exact prefix for your forum in Admin > Server Settings > Database Tables Prefix -- if it is different from smf_ then you have to modify the query before running it in phpMyAdmin.


[edit]
Also check the variables mentioned in this post:
http://www.simplemachines.org/community/index.php?topic=165442.msg1056581#msg1056581

Quote from: Sarge on November 24, 2007, 10:26:19 PM
You don't have to post multiple times. If there's no reply after your last post, simply edit it.

Yes, it seems to be a Fantastico bug. It sets global_character_set as UTF-8 even if the tables are in latin1.

First, make a backup of your forum database. Then delete global_character_set from smf_settings (read reply #10 in this topic about how to do that). Then go to SMF Admin > Forum Maintenance and run "Convert the database and data to UTF-8?" -- SMF will convert the forum tables and set global_character_set to UTF-8.

Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

Sarge

Quote from: Sarge on November 24, 2007, 10:26:19 PM
Then go to SMF Admin > Forum Maintenance and run "Convert the database and data to UTF-8?" -- SMF will convert the forum tables and set global_character_set to UTF-8.


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

wtt

I knew that and I have done that successfully with your previous post. Cheers!
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

Sarge


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

wtt

Yes. I got that work before your last two posts. :)
Thanks a lot!

Quote from: Sarge on November 24, 2007, 10:55:50 PM
So, is it working OK now?
Bendigou( local shopping )
http://www.bendigou.com

Haoxiaoqu ( good districts )
http://www.haoxiaoqu.com

I am trying to link these two together!

polytalks

Quote from: Sarge on July 06, 2007, 01:20:34 AM
Quote from: nolefan on June 29, 2007, 01:02:57 AM
Quote from: Sarge on June 28, 2007, 07:43:21 AM
Have you converted your forum with Admin > Forum Maintenance > "Convert the database and data to UTF-8"?

I don't have anything in the forums maintenance that says " Convert Database and data to UTF-8".

Have you tried deleting the entry global_character_set = UTF-8 in smf_settings and going to Admin > Forum Maintenance again? If you do that, the link I mentioned should appear.

Open phpMyAdmin (if you can access it for your hosted account), select your forum database and click on the SQL icon. It looks like this:



Enter the query (copy/paste from below) into the box and click the Go button.

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

The query above works if your forum tables prefix is smf_ (which is the default). You can find the exact prefix for your forum in Admin > Server Settings > Database Tables Prefix -- if it is different from smf_ then you have to modify the query before running it in phpMyAdmin.


[edit]
Also check the variables mentioned in this post:
http://www.simplemachines.org/community/index.php?topic=165442.msg1056581#msg1056581

where can I find entry global_character_set = UTF-8 in smf_settings?? and which smf setting that you are regarding to?

thanks

Relyana

Brilliant ! This should be in "tips and tricks". You have no idea how long I searched for a fix to my problems with the Romanian diacritics (ok in preview, not ok in submitted posts). 

Thank you !!!  O:)

Sarge

Quote from: Sarge on November 24, 2007, 10:26:19 PM
... it seems to be a Fantastico bug. It sets global_character_set as UTF-8 even if the tables are in latin1.

Therefore, it's not really suitable for Tips and Tricks, because the issue does not happen when you upload SMF files by yourself and install SMF using install.php (not using an auto-installer like Fantastico).

We have contacted Netenberg, the developer of Fantastico. At the time of writing, we are still waiting for a response from them.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Relyana

You're right, forgive my enthusiasm. My forum is no longer "connected" to Fantastico.  :)
The weird thing is that soon after I fixed the utf-8 character issue some of the posts disappeared .... I mean they were there in their threads but with no words or smileys or anything ... just blank posts. It didn't bother me though, they're gone for good now and everything's fine.   :D


Sarge

Quote from: Relyana on June 29, 2008, 03:58:48 PM
You're right, forgive my enthusiasm. My forum is no longer "connected" to Fantastico.  :)
The weird thing is that soon after I fixed the utf-8 character issue some of the posts disappeared .... I mean they were there in their threads but with no words or smileys or anything ... just blank posts. It didn't bother me though, they're gone for good now and everything's fine.   :D

Test with accented and other special characters (for example ä, 中文, " etc). If you still experience any issues, start a new topic (and post the topic link here).

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Relyana

Quote from: Sarge on June 30, 2008, 02:46:07 AM
Test with accented and other special characters (for example ä, 中文, " etc). If you still experience any issues, start a new topic (and post the topic link here).

Thanks Sarge but everything's perfect (or maybe it's just my proverbial luck.  :P )

smurfyforum

I am having this same problem - but I do not want to convert to UTF8, how do I solve this without converting?

"Smurfs, Smurfs, and More Smurfs!"

Sarge

Quote from: pvcblue™ on January 11, 2009, 02:18:14 AM
I am having this same problem - but I do not want to convert to UTF8, how do I solve this without converting?

What special characters are you having issues with?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

smurfyforum

I have a member form finland and when he posts the apostrophies and stuff come out different characters, also like my user name here if I try to add the ™ to my name on my profile I get that error -

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
File: /home/mysite/public_html/mysite/forum/Sources/Subs-Members.php
Line: 904


"Smurfs, Smurfs, and More Smurfs!"

smurfyforum

oh line 904 in my subs-member says

      LIMIT 1", __FILE__, __LINE__);

"Smurfs, Smurfs, and More Smurfs!"

Sarge

Quote from: pvcblue™ on January 11, 2009, 02:56:34 AM
oh line 904 in my subs-member says

      LIMIT 1", __FILE__, __LINE__);

That's the last line of that query. Copy the lines before that (starting with the line that says db_query) and paste them here.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

smurfyforum

ok here is the whole section



// Make sure they don't want someone else's name.
$request = db_query("
SELECT ID_MEMBER
FROM {$db_prefix}members
WHERE " . (empty($current_ID_MEMBER) ? '' : "ID_MEMBER != $current_ID_MEMBER
AND ") . "(realName LIKE '$checkName' OR memberName LIKE '$checkName')
LIMIT 1", __FILE__, __LINE__);
if (mysql_num_rows($request) > 0)
{
mysql_free_result($request);
return true;
}

// Does name case insensitive match a member group name?
$request = db_query("
SELECT ID_GROUP
FROM {$db_prefix}membergroups
WHERE groupName LIKE '$checkName'
LIMIT 1", __FILE__, __LINE__);
if (mysql_num_rows($request) > 0)
{
mysql_free_result($request);
return true;
}

// Okay, they passed.
return false;
}



"Smurfs, Smurfs, and More Smurfs!"

Sarge

Is line 904 before or after this:

// Does name case insensitive match a member group name?

???

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

smurfyforum

Quote from: Sarge on January 11, 2009, 03:38:59 AM
Is line 904 before or after this:

// Does name case insensitive match a member group name?

???

904 is before - that is line 911

"Smurfs, Smurfs, and More Smurfs!"

smurfyforum


"Smurfs, Smurfs, and More Smurfs!"

Sarge

Let's see...

When using UTF-8, SMF issues "SET NAMES utf8" before dealing with database data; that SQL command overrides latin1 or any other charset in the MySQL configuration and database setup.

When SMF is not using UTF-8, it uses the MySQL default charsets. In your case, it seems that MySQL is using UTF-8, but the database data are in latin1.

You can force SMF to use latin1 explicitly. One way to do this is to add $db_character_set in Settings.php (in your main forum directory). Make a backup copy of Settings.php before modifying it!

1. Download Settings.php from your forum directory to your computer.
2. Open it in a text editor.
3. Search for $db_character_set in the file.
4.
    a) if there's no line that starts with $db_character_set, find this (at the end of the file):

?>

    and before that line, add this:

$db_character_set = 'latin1';

    b) if $db_character_set is already set (to 'utf8', maybe?), set it to 'latin1' as above.
5. Save the file and upload it to your forum directory. Make sure that it replaces the original Settings.php.

Again: make a copy of Settings.php before modifying it!

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

smurfyforum

THAT WORKED!!! THANK YOU SOOOOOOOOOOOOOOOOOOOOOOO MUCH!! This has been making me nuts for a month now!! LOL!!!


"Smurfs, Smurfs, and More Smurfs!"

Sarge

Glad it helped! :)

A word of advice: Next time, please start new topics for your own issues. Topics marked as solved are not checked by the Support Team. (I noticed your reply only because I had set notifications for this topic.) Also, asking for support about your own issues in other people's topics is generally not recommended.

Thank you! :)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

albanian

I wont to convert Albanian Character  how do i ?  If AN Albanian Can help me in albanian is more simple for me,,,, My email erion.ita@gmail.com

Sarge

Quote from: albanian on January 30, 2009, 07:38:40 PM
I wont to convert Albanian Character  how do i ?  If AN Albanian Can help me in albanian is more simple for me,,,, My email erion.ita@gmail.com

Hello Erion, we have an Albanian language board here. ;)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

albanian


cold77

Thank you Sarge is worked for me!

Quote from: Sarge on July 06, 2007, 01:20:34 AM
Quote from: nolefan on June 29, 2007, 01:02:57 AM
Quote from: Sarge on June 28, 2007, 07:43:21 AM
Have you converted your forum with Admin > Forum Maintenance > "Convert the database and data to UTF-8"?

I don't have anything in the forums maintenance that says " Convert Database and data to UTF-8".

Have you tried deleting the entry global_character_set = UTF-8 in smf_settings and going to Admin > Forum Maintenance again? If you do that, the link I mentioned should appear.

Open phpMyAdmin (if you can access it for your hosted account), select your forum database and click on the SQL icon. It looks like this:



Enter the query (copy/paste from below) into the box and click the Go button.

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

The query above works if your forum tables prefix is smf_ (which is the default). You can find the exact prefix for your forum in Admin > Server Settings > Database Tables Prefix -- if it is different from smf_ then you have to modify the query before running it in phpMyAdmin.


[edit]
Also check the variables mentioned in this post:
http://www.simplemachines.org/community/index.php?topic=165442.msg1056581#msg1056581

Smoking Mountains

August 21, 2009, 05:49:03 AM #47 Last Edit: August 21, 2009, 06:01:54 AM by Smoking Mountains
I'm having the same problem of not able to display chinese characters. I used the "Fantastico De Luxe" to install the SMF as well. I've tried Sarge's suggestion by running this code below

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

and then "Convert HTML-entities to UTF-8 characters" in "Forum Maintenance".

But i'm not as lucky.  :-[

Attached is the server variables and settings. Any suggestion? Thank you!

Smoking Mountains

i guess this shows the problem? should i change all the "latin1_swedish_ci" to "utf8_general_ci"? if so, how do i do that?

thanks.

Norv

Please post a link to your forum.
Also, if you have in Admin > maintenance the option to "Convert the database and forum to utf8", perhaps you can try that, but only after making a complete backup of the database. (preferably using phpMyAdmin's "Export" feature for backup).
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Sarge

Quote from: Smoking Mountains on August 21, 2009, 05:49:03 AM
I've tried Sarge's suggestion by running this code below

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1;

and then "Convert HTML-entities to UTF-8 characters" in "Forum Maintenance".

1) Are you sure it wasn't "Convert the database and data to UTF-8"? The other option ("Convert HTML-entities to UTF-8 characters") should appear only after the conversion, not before.

2) Also, if you have a copy of Settings.php from before the conversion, see if there is a line for $db_character_set (see reply #40 in this topic for more details.)


Quote from: Smoking Mountains on August 21, 2009, 05:49:03 AM
But i'm not as lucky.  :-[

3) What encoding does your browser use when visiting your forum? In Firefox it can be seen at View menu > Character Encoding, and in Internet Explorer at View > Encoding.


Quote from: Smoking Mountains on August 21, 2009, 06:03:32 AM
i guess this shows the problem? should i change all the "latin1_swedish_ci" to "utf8_general_ci"? if so, how do i do that?

Yes, that probably means that the conversion didn't happen. Please see my three questions above (don't modify anything for the moment.)

Oh, and absolutely get a full backup of the database before making any more changes, as Norv said.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Smoking Mountains

Thank you Norv. My site was just created, so it is pretty much empty. But here is a link to the post that is supposed to be in Chinese. hxxp:forums.lanbud.com/index.php?topic=5.msg6#new [nonactive]

Smoking Mountains

Quote from: Sarge on August 21, 2009, 06:18:46 AM
1) Are you sure it wasn't "Convert the database and data to UTF-8"? The other option ("Convert HTML-entities to UTF-8 characters") should appear only after the conversion, not before.

Oh, and absolutely get a full backup of the database before making any more changes, as Norv said.

Thanks Sarge. Please see attached image. I'm backing up the forum now.

Sarge

I see that your forum is brand new, so you don't really have anything to backup. At worst, you could simply delete and/or reinstall it :)

Please see my second question:
Quote from: Sarge on August 21, 2009, 06:18:46 AM
2) Also, if you have a copy of Settings.php from before the conversion, see if there is a line for $db_character_set (see reply #40 in this topic for more details.)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Smoking Mountains

Quote from: Sarge on August 21, 2009, 06:18:46 AM
2) Also, if you have a copy of Settings.php from before the conversion, see if there is a line for $db_character_set (see reply #40 in this topic for more details.)

i just checked this. that line was already
$db_character_set = 'utf8';

and i changed it to
$db_character_set = 'latin1';

but it didn't make a difference.

Smoking Mountains

aha, it is working now!!!!

after i changed the "utf8" to "latin1" per your suggestion, and went to "Forum Maintenance", there was the option to convert the database, after i did that, i did "Convert HTML-entities to UTF-8 characters" as well.

wow. problem fixed!

thank you so much!!!

i was chatting with the web host tech support guy and he told me "we can't help you."

Sarge

Quote from: Smoking Mountains on August 21, 2009, 06:50:02 AM
after i changed the "utf8" to "latin1" per your suggestion, and went to "Forum Maintenance", there was the option to convert the database, after i did that, i did "Convert HTML-entities to UTF-8 characters" as well.

Be sure to change that line back to "utf8", if this wasn't done automatically by the conversion. Anyway, I'm glad to know it's fixed now. :)

Also, due to the way support is done here, please be sure to start your own topics for your own support questions. Thank you! :)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

allanmiller99

Thanks! Its working for me also.

Great help!

retireincebu.com

Advertisement: