Convert .txt to MySQL

tanha · #1 (**permalink**) 10-09-07, 03:42

Hello everybody,
I have this text file, and when I import them into mysql through phpMyAdmin, everything is ok, but the persian (Farsi) not shown correctly, also I use ' utf8_persian_ci ' collation, can anyone kindly plz convert this file into MySQL that farsi data shows correctly too?

NOTE:
farsi "persian" is a language

thrash.zhai · #2 (**permalink**) 10-09-07, 22:43

maybe the type of file is incorrect

healdem · #3 (**permalink**) 10-10-07, 04:36

how do you know its not storing things correctly in MySQL?

is it possible that the client you are using to view the data doesn't understand which character set to use?

Pat Phelan · #4 (**permalink**) 10-10-07, 10:16

The Unicode data in your TXT file is a mix of Roman and Cyrillic. There are no character I recognize as Farsi (Arabic characters) in the portion of the file that I scanned.

Does the contents of this file appear as English/Farsi on your screen?

-PatP