data was not displayed in the application in the correct format.

[honeyboy_20]

The problem that we want you to help us in solving it is as follows :
We have an excel sheet containing some data.
We want to import this data to a mySql database to be used by a certain application.
By importing this data through transferring it to CSV format, the data was successfully imported but the Arabic data was not displayed in the application while this data is displayed during browsing the database inside the MySql.
If the data is entered through the application and then retrieved , the Arabic data is displayed correctly.

We need to import this data (excel sheet) inside the MySql such that it is displayed correctly inside the application.


Hint :I'm use UTF-8

[PeejAvery]

Since you're dealing with transfer, you need to make sure that every step has the same encoding.

• Is your CSV properly exported in UTF-8
• Are your database fields set to collate in UTF-8
• After import into the database, do they retain UTF-8
• Is your output script saved in UTF-8 (the one which handles reading from the databae)
• Does your output page to HTML have header for UTF-8 format

[honeyboy_20]

Thanks for your reply.

I'm consider all what you say.

The following Scenario happen :-

When i try to insert from my admin page the Arabic word appear and stored in db to be unreadable as the following الجÙÅ*زة

and if i try to insert value direct to db table , i read it as the following in admin page ????

I want to read in both Arabic

[PeejAvery]

Sounds like either #2 or #4 in my list are happening to you.

[honeyboy_20]

How i can handle "Is your output script saved in UTF-8 (the one which handles reading from the databae)"

[PeejAvery]

The script that handles the passing of data to/from the database...does it have a UTF-8 header? And that script itself should be saved as a UTF-8 file.