Icy Phoenix
Old Support Topics - Convert From Iso-8859-7 To Utf-8
Costa [ Sun 02 Sep, 2012 20:07 ]
Post subject: Convert From Iso-8859-7 To Utf-8
We try to update from 1.3.0.53a to the latest version of IP but, we are in GReece and we use greek letters to our forums. So, after the update instractions we take the IP but not the greek letters in forum.
We use the latest WAPP in local PC and the tables of mySQL is also "not greek"
Do you have any idea in order to make the convertion work's for us?
Any help is welcome.
Costa [ Sun 02 Sep, 2012 21:14 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
...
like point 15 and 18?
yes..
more then 3 times
Joshua203 [ Sun 02 Sep, 2012 21:53 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Well I'm very unshure about this stuff tbh, but have you tried running some stuff in DB And Security>>Database Maintenance?
Costa [ Mon 03 Sep, 2012 13:40 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
The problem starts after the first step, the convertion to utf-8, nothing to do with DB Maintenance of IP admin panel. The usally problem with Greek letters.
TheSteffen [ Tue 04 Sep, 2012 10:55 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Sorry, I have to ask a seconde time:
Did you copy convert_utf8_nodbal.php to your root and launched it?
There should be anything wrong.
Did you get an error there?
Mighty Gorgon [ Mon 10 Sep, 2012 23:50 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Did you convert your tables as Steffen pointed out?
TheSteffen [ Tue 11 Sep, 2012 09:57 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Did you convert your tables as Steffen pointed out?
The script is not working for him.
I have his DB and tryed on my own.
Now I will convert it for him to UTF8 manual.
It is not everthing working fine now... but I am close to it

Costa [ Tue 11 Sep, 2012 13:26 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
I admit that Steffen is doing a gread job.
Is trying to solve un DB >600Mb composed of Greek letters

After this I believe that science will have made a step forward

TheSteffen [ Tue 11 Sep, 2012 16:50 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Costa,
This are my steps for YOU to convert your latin1 greek letters to utf8
Steps:
1. open a33.sql
2. save as utf8 without bom
3. reimport with mysqldumper as utf8
4. export again as latin1
5. open this new file with Notepad++ or UltraEdit
6. change Character Set to "Greek -> ISO-8859-7" (menu Encoding->Character Sets->Greek->ISO-8859-7)
7. Convert the document to UTF-8 (menu Encoding->Convert to UTF-8)
8. replace any instances of "latin1_bin" with "utf8_bin" and "latin1" with "utf8" in the document (use search and replace)
9. search for CHARSET=utf8; and replace with CHARSET=utf8 COLLATE=utf8_bin;
9. Save as UTF8 without bom
10. reimport with mysqldumper
Maybe there is a shorter way... I am not an expert

Mighty Gorgon [ Sat 15 Sep, 2012 11:34 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
So you managed to convert the DB properly?

TheSteffen [ Sat 15 Sep, 2012 13:38 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Yes, it looks like...

Mighty Gorgon [ Sun 16 Sep, 2012 12:59 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Costa [ Mon 17 Sep, 2012 12:10 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Great man... I will name you "Mr. UTF-8"
....
Oou yes Luca...
You can not imagine what he had to go, is large enaught my site with thausands of post, photo album, games ...
First of all I must say that the update from 1.3.0.53a to ICY 2 is ok now with TheSteffen.
So is better that Steffen explaining some steps also useful for others.
But now as I now he's in holiday.
I have to thank him, hi si very good and my help was much moral support.
Joshua203 [ Mon 17 Sep, 2012 13:12 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
I have a feeling he even went a day later than planned
Please don't forget to mark this SOLVED if it is fully solved Costa ...thanks
Costa [ Mon 17 Sep, 2012 14:01 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Yeap Joshua203,
But I keep it open until cam back Steffen for the steps.
Hi now better than me, whather they will be userful for others and not only with regard to the Greek letters.
Thank's u to, for your contribution and your interest.
TheSteffen [ Mon 24 Sep, 2012 11:37 ]
Post subject: Re: [SOLVED] Convert From Iso-8859-7 To Utf-8
Topic is solved

Joshua203 [ Mon 24 Sep, 2012 11:42 ]
Post subject: Re: Convert From Iso-8859-7 To Utf-8
Welcome back Steffen
