SMF Community Helpers > SMF Documentation Help

How to convert to UTF-8

<< < (4/5) > >>

agridoc:
I do agree that it must be a separate page, it's too big to be added in UTF-8 Readme page, a link should be added there for "a more comprehensive guide" or something like that.

I am thinking of adding a section for a special case that must be quite frequent. SMF started as ISO/ANSI installation then a UTF-8 language was added and mostly used. While it shows as UTF-8 it isn't, although data is stored as UTF-8 in latin1_swedish_ci tables. I have done, tested and helped to do such conversions with 1.1x, not with 2.0x yet. I will test when I find time. It should work the same but some tests must be done to be completely sure.

AngelinaBelle:
So I think it would be perfect if you go to http://wiki.simplemachines.org/smf/How_to_convert_your_forum_to_UTF-8
You will see it does not exist, but it will tell you how to get started on that document.

Put in there all the instructions you have so far.

After that, everyone who is allowed to edit the wiki (all users with at least 10 posts) will be able to make changes.
Usually, these changes are improvements. But you can watch that page to see how it develops.

Thanks!

Antechinus:
Suggestion, quoted from one of my posts in the dev boards:


--- Quote ---And no way would I try and convert my live db and rely on restoring a backup if things went wrong. I've got more sense than that. I'd just copy the existing db over to a new one and convert that, then point the forum at it. Much easier to fix if things go wrong.
--- End quote ---

agridoc:
There is this that is similar but not the same.


--- Quote from: agridoc on April 01, 2012, 04:25:33 AM ---In small forums, with simple mods only, steps 1,4,5 and 7 might not be necessary. If conversion fails. use the backup to restore the database and follow all steps or consider to test locally in your PC first.

In medium to large forums it's better to test in your PC first. The safest way is to backup, restore locally in a PC with XAMPP or similar and make tests, following the steps. This way, an admin can have a safe training and test to see if additional problems might occur in a particular conversion.
...
Green text: Based on suggestion by Dzonny.
--- End quote ---

Still there would be much work to install again mods, themes etc. However one might do
- Put the forum in maintenance mod
- Copy SMF tables to another DB.
- Install a small simple mod.
- Point SMF to new DB
Then follow the conversion steps.

So in case that something goes wrong it will be easy to point back to original DB and revert to backup before last mod install.

AngelinaBelle:
So -- is this information ready to create a how-to on the wiki?

As long as the information is correct, please put it on the wiki and discuss here. We can continue to edit and improve.

Thanks!

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version