UTF-8 CSV import ok but after processing with utf-8 shapefile accent replaced by '?'

Question

I m using QGIS 2.18

I export data from SQL Developer to a csv file with ";" as separator and with UTF-8 encoding.

Then, I have imported the csv with UTF-8 encoding. Accents were imported right.

But after processing a join by attributes between CSV and a Shapefile with .cpg "UTF-8" the accents disappear:

What's the matter? Is it from ogr2ogr sub "processing" that does not support the accents?

Please specify exactly which tool was used for the join by attribute operation. — underdark♦, Nov 30 '16 at 15:13
EDIT : In Modeler, i use field calculator to convert the floats number into integer in the csv table then i can join on this new field the Shapefile where the numbers to join are integers. I see the problem appears at the Field calculator step. I just tested with a join with no match (because of float numbers) and the accents are ok — jlSta, Nov 30 '16 at 16:24
Thanks to @rjhale This is a bug There is a workaround but how could i implement it in models? — jlSta, Dec 8 '16 at 17:07

jlSta · Accepted Answer · 2017-02-22 17:06:27Z

2

Works for me. Checked in 2.18.3

Change the Processing encoding in Advanced Settings 'System' to 'UTF-8' or any other encoding

answered Feb 22 '17 at 17:06

jlSta

4522 silver badges19 bronze badges

add a comment |

1 Answer 1