Advertisement:

Author Topic: UTF-8 Conversion  (Read 116746 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
UTF-8 Conversion
« on: January 08, 2007, 09:39:10 PM »
I'm looking into adding UTF-8 support to the converter.  Before I do that I want to try this first to see if it will work.  After installing SMF go to Admin > Forum Maintenance > Convert to UTF-8.  That will convert the tables and column to the UTF-8 collation.  After that try the converter.  Doing that should work for the most part.  If not I'll look at another alternative.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #1 on: January 18, 2007, 12:55:33 AM »
Ok this is a test converter to test UTF-8 stuff out.  Let me know how it goes.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline madru

  • Newbie
  • *
  • Posts: 4
Re: UTF-8 Conversion
« Reply #2 on: January 18, 2007, 01:13:13 AM »
Negative. Same thing and this time I got an error. I ticked the new option of converting to UTF-8 (I did a fast clean install again) and here is what I got:
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images...
Fatal error: Cannot redeclare copy_dir() (previously declared in /var/www/site/forum/convert.php:2108) in /var/www/site/forum/convert.php(682) : eval()'d code on line 19

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #3 on: January 18, 2007, 01:17:54 AM »
Ok that error is due to a change that I made in convert.php.  I have to update the phpbb2_to_smf.sql to reflect the change.  I'll update it now and post in the topic.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline odbayarb2000

  • Semi-Newbie
  • *
  • Posts: 15
  • Gender: Male
    • Student Community
Re: UTF-8 Conversion
« Reply #4 on: February 17, 2007, 11:55:29 PM »
I have already converted my forum and it turned into alien language lol.
Is there any way to change the character settings into UTF-8 after everything has done. I mean After converted.
Please help me.
Also I want to translate SMF into my own language. How should I start. Please show me the way.
Thanks for your support
http://www.oitamongols.com/ [nofollow]
Accessibility: All Browsers(I believe)
Language: Mongolian
Content: Student Community

Offline odbayarb2000

  • Semi-Newbie
  • *
  • Posts: 15
  • Gender: Male
    • Student Community
Re: UTF-8 Conversion
« Reply #5 on: February 19, 2007, 02:39:45 AM »
Hey Guys,
I want to convert my phpbb 2.0.22 forum into SMF 1.1.2.
I have done everything as suggested as here.
The forum has converted successfully. But unfortunately,   I have character set error.
My entire forum is non-english. What should I do now. Please help me ASAP.  
http://www.oitamongols.com/ [nofollow]
Accessibility: All Browsers(I believe)
Language: Mongolian
Content: Student Community

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #6 on: February 26, 2007, 10:30:08 AM »
What collation are the tables set to for SMF?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline whitewash

  • Semi-Newbie
  • *
  • Posts: 32
Re: UTF-8 Conversion
« Reply #7 on: March 06, 2007, 02:32:06 AM »
Where can I find the phpbb2_to_smf.sql for UTF8?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #8 on: March 26, 2007, 03:17:36 PM »
Ok give this one a try.  Install SMF with the correct charset that you want to use then convert.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boki

  • Semi-Newbie
  • *
  • Posts: 21
Re: UTF-8 Conversion
« Reply #9 on: March 27, 2007, 09:04:46 AM »

I've tried and got this error message:

Quote
Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images...
Fatal error: Cannot redeclare copy_dir() (previously declared in /home/drugacen/public_html/smf/convert.php:2096) in /home/drugacen/public_html/smf/convert.php(671) : eval()'d code on line 1

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #10 on: March 28, 2007, 12:10:10 AM »
What converter are you using?  I mean the .sql file.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boki

  • Semi-Newbie
  • *
  • Posts: 21
Re: UTF-8 Conversion
« Reply #11 on: March 28, 2007, 11:06:01 AM »
I'm using the .sql file from "download" page, as you posted only php file on this forum...  

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #12 on: March 28, 2007, 01:31:59 PM »
Where are you converting from?  What software?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boki

  • Semi-Newbie
  • *
  • Posts: 21
Re: UTF-8 Conversion
« Reply #13 on: March 28, 2007, 01:37:04 PM »
I'm converting from phpBB 2.0.21

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #14 on: March 28, 2007, 01:48:10 PM »
Try using the converter in this topic: phpBB 2.0.19+ along with the convert.php from here.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boki

  • Semi-Newbie
  • *
  • Posts: 21
Re: UTF-8 Conversion
« Reply #15 on: March 28, 2007, 02:03:23 PM »
Nothing... still the same problem

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: UTF-8 Conversion
« Reply #16 on: March 28, 2007, 03:12:35 PM »
Meaning same UTF-8 problem or conversion problem?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline haco

  • Newbie
  • *
  • Posts: 4
Re: UTF-8 Conversion
« Reply #17 on: July 30, 2007, 01:04:10 PM »
thank you very much

Offline koyukaranlik

  • Newbie
  • *
  • Posts: 3
Re: UTF-8 Conversion
« Reply #18 on: July 30, 2007, 03:33:14 PM »
thanks

Offline hamade_ima

  • Newbie
  • *
  • Posts: 6
Re: UTF-8 Conversion
« Reply #19 on: August 01, 2007, 06:06:27 AM »
thanks