Click here to Skip to main content
12,954,276 members (91,032 online)
Rate this:
Please Sign up or sign in to vote.

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 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..&>
Posted 29-Sep-12 22:27pm
Bernhard Hiller 1-Oct-12 4:14am
Is there some character set mentioned in the html headers of the old php web site?
WaleedMuh 1-Oct-12 5:30am
Yes, "<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">"
Bernhard Hiller 2-Oct-12 2:11am
When you export the db with "Windows-1256", does it look correctly? Otherwise, some "conversion" will be required, but that might be complicated...
WaleedMuh 2-Oct-12 6:08am
It show ? instead of letters when exported as "Windows-1256",
Can you please guide me through the conversion? I much need it.. thanks

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Kenneth Haugland 30-Sep-12 5:42am
Simulated resopnse:

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,524
CHill60 3,490
Maciej Los 3,123
ppolymorphe 2,030
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 30 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100