Bug report #15091

qgis 2.14 and 2.15 - problem of character encoding with "virtual layer"

Added by jerome potel over 8 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Unknown
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:23033

Description

Hello,

I try to utiiser "virtual layer" with an encoded layer 'latin1'.

I want to change the value of an attribute of a single record.

I write this for a fairly simple query :

SELECT 
    ROWID id,
    "INSEE_COM",
    "NOM_COM",
    CASE WHEN "INSEE_COM"='14118' THEN 'Préfecture de département' ELSE "STATUT" END AS STATUT,
    geometry
FROM "COMMUNE" WHERE "CODE_DEPT"='14'

It works well, but the result is encoded in ' latin1 ' when the change was made probably in utf8 (cf. image)

result.jpg (431 KB) jerome potel, 2016-06-21 09:55 AM

History

#1 Updated by jerome potel over 8 years ago

#2 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Jürgen Fischer about 7 years ago

  • Category set to Unknown

#4 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF