Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007

    Unanswered: Convert .txt to MySQL

    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?

    farsi "persian" is a language
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2007
    maybe the type of file is incorrect

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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?
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    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?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts