Comments |
Re: Convert From Iso-8859-7 To Utf-8
|
Can you confirm you have done all the upgrade steps Costa?
http://www.icyphoenix.com/docs/readme_english.html#upgrade_ip
like point 15 and 18?
|
Joshua203 [ Sun 02 Sep, 2012 21:07 ]
|
|
Re: Convert From Iso-8859-7 To Utf-8
|
...
like point 15 and 18?
yes..
more then 3 times
|
Costa [ Sun 02 Sep, 2012 21:14 ]
|
|
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?
|
Joshua203 [ Sun 02 Sep, 2012 21:53 ]
|
|
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.
|
Costa [ Mon 03 Sep, 2012 13:40 ]
|
|
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?
|
TheSteffen [ Tue 04 Sep, 2012 10:55 ]
|
|
Re: Convert From Iso-8859-7 To Utf-8
|
Did you convert your tables as Steffen pointed out?
|
Mighty Gorgon [ Mon 10 Sep, 2012 23:50 ]
|
|
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
|
TheSteffen [ Tue 11 Sep, 2012 09:57 ]
|
|
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
|
Costa [ Tue 11 Sep, 2012 13:26 ]
|
|
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
|
TheSteffen [ Tue 11 Sep, 2012 16:50 ]
|
|
Re: Convert From Iso-8859-7 To Utf-8
|
So you managed to convert the DB properly?
|
Mighty Gorgon [ Sat 15 Sep, 2012 11:34 ]
|
|
Re: Convert From Iso-8859-7 To Utf-8
|
Yes, it looks like...
|
TheSteffen [ Sat 15 Sep, 2012 13:38 ]
|
|
Re: Convert From Iso-8859-7 To Utf-8
|
|
Mighty Gorgon [ Sun 16 Sep, 2012 12:59 ]
|
|
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.
|
Costa [ Mon 17 Sep, 2012 12:10 ]
|
|
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
|
Joshua203 [ Mon 17 Sep, 2012 13:12 ]
|
|
|