Non-latin characters in csv import
Posted: 13 Apr 2021, 20:26
Hi,
My csv import does not work with non-latin characters. Even though I am using Unicode UTF-8 in the csv file as indicated, and the special characters are displayed correctly by OpenOffice, the import fails with an error message that the number of collumns varies in the rows. The special characters lead to more columns, line breaks and other issues.
Especially I have trouble with:
- Apostrophes and special quotation marks
- Ellipsis (dot-dot-dot)
- Chinese characters
- Extended Latin characters (Danish, Hungarian, etc.)
- Line breaks.
Can anyone help me?
My csv import does not work with non-latin characters. Even though I am using Unicode UTF-8 in the csv file as indicated, and the special characters are displayed correctly by OpenOffice, the import fails with an error message that the number of collumns varies in the rows. The special characters lead to more columns, line breaks and other issues.
Especially I have trouble with:
- Apostrophes and special quotation marks
- Ellipsis (dot-dot-dot)
- Chinese characters
- Extended Latin characters (Danish, Hungarian, etc.)
- Line breaks.
Can anyone help me?