I need to move data from a legacy website that's built using php and mysql to a new website built by .Net and SQlServer.. Most of the database content are in Arabic.
The problem i'm facing is that the mysql db is encoded as 'latin-1', when i view the db using online ecplorer or mysql workbench it shows weird chars, but it's working fine in the old php website (seems like php has a way to convert it to proper encoding)..
But when showing data using asp.net pages it still shows weird chars..
I've tried to export the db to utf-8 but it didn't work(it only converts the rows to be added, not the one's that already exists), also I've tried adding the following meta tag to my html:
Thanks in advance..&>