The text files are in Windows 1252 encoding. When importing them I chose
this encoding but as you can see from the screenshot it shows an encoding of
utf-8. When I import this layer in a Windows 1252 encoded database on
Postgresql I get no french characters.
Is this a bug?
Any idea how to get this text files imported in postgresql so that french
characters are shown?
> The text files are in Windows 1252 encoding. When importing them I
> chose this encoding but as you can see from the screenshot it shows
> an encoding of utf-8.
Which version of QGIS are you using? With stable and master QGIS3,
I cannot reproduce it with the file attached. Be aware that it gets
UTF-8 once imported to QGIS. So it'll be UTF-8 in the table, too.
[local] tobwen@qgis=# select * from public.french
│ id │ quote │
│ 1 │ Lhabit ne fait pas le moine │
│ 2 │ Chacun voit midi à sa porte │
│ 3 │ Mieux vaut prévenir que guérir │
If I understand you correctly the table in QGIS is in utf-8.
When I open the table I see that the french characters show up correct.
In stead of setting my database to 1252 West-Europees Windows I should set
it up in utf-8.
I created a test database from pgadmin and the defaults where alright.
Now I see the correct characters in my table.