更改列编码mysql显示为阿拉伯语

Question

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

Answer 1

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 ....