Home Forums Newsletter Plugin Support Database Error – Import csv with special characters – UTF8

  • This topic has 2 replies, 3 voices, and was last updated 6 years ago by Anonymous.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #84520
    Anonymous
    Inactive

    When importing .csv I get a database error.
    In the folder no logs were found.

    I found out that the import works until the first special character, then it is canceled.
    cvs is in UTF8 format and the status panel shows blog charset and database chartset as UTF8 format.

    What can it be or how do I create a csv that works?

    #84610
    Stefano
    Keymaster

    if the database is utf-8 almost surely the file is not utf-8. Check it with an editor which lets you to switch between utf-8 and iso charsets.

    Stefano.

    #98206
    Anonymous
    Inactive

    Followed the advise of Stefano. Now the entry is skipped. Curious thing is when I add the record by hand, I can copy the text from the spreadsheet I exported the original CSV from and the “é” is accepted.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.