News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

How to use utf-8 encoding

Started by CapriSkye, January 06, 2005, 07:39:03 AM

Previous topic - Next topic

CapriSkye

i've read in couple posts about how to use utf-8 encoding for their forums, and just thought somebody might be interested in how i changed mine to utf-8.
i don't know about other languages, but my board was in big5 encoding and changing to utf-8 would cause alot of problems. but these are the steps i took:

  • backup database, either with phpmyadmin or smf's build in function
  • open the sql file with an editor, then save as with utf-8 encoding
    big5 needs to have BOM turned off to work, so check to see if your language needs it
    both emeditor and ultraedit can do utf-8 conversion
    some converter will cause special characters to change, like html entity, make sure the one you're using isn't doing that
  • after the file is saved in utf-8, check for special characters that cause problem in database, again depends on the language you're converting
  • if everything looks ok, start importing the sql file using phpmyadmin
  • if you get an error, it probably means that your converter has changed some characters during the conversion, try with another converter or you're screwed
  • if you didn't get any error, go to your forum now and it will probably show weird characters, that means the language files you're using are not in utf-8. you'll have to convert every files in the language folder to utf-8.

that's pretty much all you have to do, hope this helps someone  :D

coderski

Thanks for an excellent advice!  I've just converted my db from ISO-8859-2 to UTF-8 with EmEditor.  Some things are just too easy - once you know how. 

smf 1.1.4

metallica48423

you know that this is almost 2 years old now, and that SMF supports utf8 in the base install now, right? :P
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Advertisement: