We have a large utf8_general_ci database with many tables and fields.
In those tables and feilds, are words and characters saved in iso-8859-1 format. The actual display format is iso-8859-7
We need a script, to read the data, convert that from iso-8859-1 to iso-8859-7 and then save it back correctly in utf8 to the database.
As an example:
There is record in the database shown as ÓõæçôÞóåéò
To get it to display correctly you convert that from iso-8859-1 to iso-8859-7 it displays correctly as Συζητήσεις
We need that correct result saved back to the database as utf8_general_ci
25 pekerja bebas membida secara purata $133 untuk pekerjaan ini
Hello. I understand the problem that you have. I can create a php script which will go over the database rows and perform the decoding / conversion as you require. I have handled with encoding issues in the past too.