CODEWITHSUNDEEP
phpmysqlcsvutf-8
SAR
SAR

Reputation: 1845

importing CSV file to mysql, there is in persian(utf-8) formate text

Structure of mysql table:

id-----int
name---var-----utf8_persian_ci

after saveing the EXCEL file as a file.csv and importing it from phpmyadmin it's showing the text in database like:

????? ??? ???? 䟪? 㠧?驥

even my mysql formate is in utf8, here when i save the text in csv and if i open csv file in notepad still it's like:

????? ??? ???? 䟪? 㠧?驥

how i can keep it work in utf8, regards in advacen

Upvotes: 0

Views: 1336

Answers (2)

saeede
saeede

Reputation: 1

when you save excel file ,you can choose CSV UTF-8 (Comma delimited) as save as type.

Upvotes: 0

SAR
SAR

Reputation: 1845

For persian excel files on importing it to mysql,

file name = file1.xls

1- the database table columns should support utf8-persian-ci
2- save .xls fiel as **Unicode Text(.txt)**--file1.txt
3- open file1.txt (now replace tab(space) to comma(,)
     you can do it by search and replace just copy the tab(space) and replace with comma(,)
4- after replaceing tab to comma , **save as** file as file1.csv 
   on encodeing--select utf-8


4- open phpmyadmin ,create database ,create table(same column) 
5- chose file1.csv
6- run import

here you are done. NOTE: the column of your table in database should be same as column in file1.csv

regards

Upvotes: 1

Related Questions