Special characters like ? are getting corrupted on import

  • Resolved bhamrick

    (@bhamrick)


    8 years, 6 months ago

    I’m importing about 150 products, many of which I’m obligated to include ? and ? in product titles and descriptions. The file is encoded using utf-8, as are my database tables. On import ? becomes ?? and ? becomes a?￠, as an example. There’s more variation than that, so it’s not as simple as a global find/replace.

    Is there a quick fix here? Or is this a bug?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author allaerd

    (@allaerd)

    Hi,

    make sure your CSV is utf08. It is , else enable utf08 conversion in the settings page

    Thread Starter bhamrick

    (@bhamrick)

    Output of file -I import.csv is text/plain; charset=utf-8. I assume that’s correct? I’ll try running it again with the conversion setting.

    Thread Starter bhamrick

    (@bhamrick)

    Ok, so after running some tests, the issue was I had Convert to UTF-08 set to “utf08 encoding” which is the default. Since my file was already utf-8 I changed it to “No” and now my characters are loading fine.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Special characters like ? are getting corrupted on import’ is closed to new replies.