Latin characters in export

  • Hello!
    How can I make the xls file recognize Latin characters? for example when exporting a publication with accents or the letter “?”, it shows other letters that do not correspond: a?o = a?±o

    In the csv export I can find the Latin characters, but the csv delimiter does not show the columns as it should. I tried with the delimiters “;” and “|”.

    thanks!!!

    • This topic was modified 4 years, 10 months ago by muztafari.
Viewing 1 replies (of 1 total)
  • Plugin Author Shambix

    (@shambix)

    Try with , (comma) instead.
    The delimiter changes depending on Language/Country settings of your PC, so check which one is correct for your Lang settings.

    About the characters, what software are you using to open the file?
    Does it work fine as csv?
    Have you tried to open it with Notepad and see if they are also wrong there?
    If not, when in Notepad, resave the file as UTF-8 then reopen with Excel. Same issue?
    What collation does your DB use?
    You can send a sample of the csv/xls and I’ll have a look.

    I use latin characters too and it works fine for me (èéòìùì).

Viewing 1 replies (of 1 total)
  • The topic ‘Latin characters in export’ is closed to new replies.