PHP Website Encoding issue

Question

I received a website , first of all i will provide some explanation: Website PHP 5.3 Mysql Database and table charset LATIN1 Meta Tags used in files are windows 12...

Now first issue is that when i see index.php file in my PC Notepad++ it shows me Arabic there but when i see the same file in my windows server notepad++ it shows different encoding.

Second i have this website which is not showing data in Arabic in browser and all the data in database is in different format/garbage characters.

Any help

Your table has the charset **LATIN1**, you need to change the charset to **UTF-8**! — Charlotte Dunois, Jan 31 '16 at 14:45
If i changed the charset of Database + Table + Column so the data will not be distrub ?? @Charlotte Dunios — GI Joes, Jan 31 '16 at 14:47
It will, because the data is in latin1. You should've set the charset of the database and whole table to UTF-8 before inserting any data. — Charlotte Dunois, Jan 31 '16 at 14:48
Brother i have this website and i need to host it . The client said me to do this i can not insert data again. — GI Joes, Jan 31 '16 at 14:50
This question is unclear, since it does not state what actually is desired. — arkascha, Jan 31 '16 at 14:51
@Arkascha-- There are 2 issues i am facing The main issue is that i need to host this website properly working means showing arabic. — GI Joes, Jan 31 '16 at 14:58
How did you try, please comment on the answer how and show what you did so we can look at what to try — Sauced Apples, Jan 31 '16 at 15:01
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; i tried these lines in mysql and then checked the encoding it is utf8 — GI Joes, Jan 31 '16 at 15:02
What is the name of the database you are using and the name of the table in the database? — Sauced Apples, Jan 31 '16 at 15:05
i have edited my answer bellow, can you try running these commands? — Sauced Apples, Jan 31 '16 at 15:22
Dear bro.. I am a programmer also i know in your previous answer that name of the database and table should be changed according to my database name... — GI Joes, Jan 31 '16 at 16:08
Ok, well the bellow answer will work. How are you running the sql? — Sauced Apples, Jan 31 '16 at 16:21
Need some more info to help you... Are you seeing Mojibake? Or question marks? `SELECT col, HEX(col) FROM ...` to see what is stored in table. For example, Arabic letter `hah` will be hex `D8AD`. — Rick James, Jan 31 '16 at 19:55

score 2 · Answer 1 · edited May 23 '17 at 11:59

2

Try using these commands;

ALTER DATABASE sdlc_demo CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE admin CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

How to convert an entire MySQL database characterset and collation to UTF-8?

edited May 23 '17 at 11:59

Community

1
1

answered Jan 31 '16 at 14:48

Sauced Apples

1,163
2
14
37

**Caution:** `CONVERT TO` should be used _only_ in the case where "A table is declared to be latin1 and correctly contains latin1 bytes, but you would like to change it to utf8." – Rick James Jan 31 '16 at 19:52

PHP Website Encoding issue

1 Answers1