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
24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.