i have table in data base and there is a column have strange language like below '20795, '1818300', '33018964', '1022251015', 'Completed without ID number',
'ÔÇÑÚ ÇáãÑÛäì - ÇáÚãÇÑå ÈåÇ ãÍá ÓÇãÓæäÌ - ÈÌæÇÑ ÚãÇÑå ÇÈæÛÇáì - Çá쾄 ÇáÓÇÈÚ-ÇáãÇÙå-ÇáÞÇåÑå'
but it was inserted as an arabic language using PHPRunner program . my question is how to update that column to seen as arabic language in mysql . i need to fix the old data .
note : values appeared normally on arabic language on the webpage my problem how to change it in DB ,.
note : the format of this table , column is UTF8
You may easily set utf8 to your tables if you are using SQLYog.
Just right click on db, table, column name and click on alter option and set to
Database Chartset = utf8 Database Collation = utf8_general_ci .
Just Enjoy ....