Bug report #4558

request and letter with accent

Added by Gilles Turgeon almost 8 years ago. Updated over 7 years ago.

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

Description

The request constructor (Properties, General) in 1.7.1 don’t recognize characters with accents in data field of SQL request (“DESCRIPTIO”=’milieu boisé’ by exemple). It return 0 object same if objects of this type are presents in data. 1.5 and 1.6 were working fine. I don't know for 1.7.0. The bug is present in 1.7.1 and 1.7.2.


Related issues

Duplicated by QGIS Application - Bug report #4763: Queries are not working if layer is not UTF8 Closed 2012-01-08

Associated revisions

Revision 2d0edcd7
Added by Jürgen Fischer over 7 years ago

ogr provider:
- support for OLCStringsAsUTF8 (fixes #4558)
- remove quotation on "ORDER BY" (produces a syntax error otherwise)
- support for null values in uniqueValues/minimumValue/maximumValue

Revision 397e3b46
Added by Jürgen Fischer over 7 years ago

ogr provider:
- support for OLCStringsAsUTF8 (fixes #4558)
- remove quotation on "ORDER BY" (produces a syntax error otherwise)
- support for null values in uniqueValues/minimumValue/maximumValue

History

#1 Updated by Paolo Cavallini almost 8 years ago

  • Category set to Data Provider

#2 Updated by Giovanni Manghi almost 8 years ago

  • Target version set to Version 1.7.4

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

  • Crashes QGIS or corrupts data set to No
  • Affected QGIS version set to master
  • Status changed from Open to Feedback

which version of GDAL are you using? Should work with GDAL >=1.8

#4 Updated by Gilles Turgeon over 7 years ago

I am using GDAL 1.8.1 on QGIS 1.7.3, Windows version. The bug is present.

The bug was present in

-  GDAL 1.8.1 on QGIS 1.7.2 
- GDAL ??? ib QGIS 1.7.1

The bug WAS NOT present in :

- GDAL ? QGIS 1.6
- GDAL ?
QGIS 1.5

Not sure for the precedent versions. I was just evaluating QGIS at this time.

#5 Updated by Alexander Bruy over 7 years ago

Seems duplicate #4227

#6 Updated by Gilles Turgeon over 7 years ago

It's seems.

I follow the suggestion of 4227 (load data set and save it as UTF-8) and the request now select data with accent in the data field.

#7 Updated by Jürgen Fischer over 7 years ago

  • % Done changed from 0 to 100
  • Status changed from Feedback to Closed

Also available in: Atom PDF