https://issues.qgis.org/https://issues.qgis.org/favicon.ico2011-08-29T20:33:49ZQGIS Issue TrackingQGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=255502011-08-29T20:33:49ZPaolo Cavallinicavallini@faunalia.it
<ul><li><strong>Category</strong> set to <i>Vectors</i></li></ul> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=261962011-10-30T22:46:24Zpeppo -
<ul></ul><p>I encountered a quite similar issue. When the query on a shape layer (on windows with system encoding) contains special characters like ü the coresponding feature is not selected. When I take the the same shape file and use the "save as ..." with utf-8, the query works fine on the new layer.</p>
<p>I think this behaviour is problematic, because one might not notice a single feature missing and it changes the result of a query.</p>
<p>If anybody needs example files, I would be happy to provide them.</p> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=263392011-11-12T04:51:04ZTim Suttontim@linfiniti.com
<ul><li><strong>Target version</strong> changed from <i>Version 1.7.1</i> to <i>Version 1.7.2</i></li></ul> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=266402011-11-30T11:40:39ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Target version</strong> changed from <i>Version 1.7.2</i> to <i>Version 1.7.3</i></li></ul> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=269832011-12-16T09:54:56ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Target version</strong> changed from <i>Version 1.7.3</i> to <i>Version 1.7.4</i></li></ul> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=287402012-01-26T03:33:12ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Affected QGIS version</strong> set to <i>master</i></li><li><strong>Crashes QGIS or corrupts data</strong> set to <i>No</i></li></ul><p>This is still confirmed on master. You can use the vector attached to <a class="issue tracker-1 status-5 priority-5 priority- closed" href="https://issues.qgis.org/issues/4433" title="Edit vertex tool very slow (Closed)">#4433</a> to test it.</p> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=287602012-01-26T10:55:08ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>The problem is worst as the same issue is there even if the layer is opened with the correct encoding and the query contains non-ascii chars</p>
<p>example:</p>
<p>download this</p>
<p><a class="external" href="http://www.igeo.pt/produtos/cadastro/caop/download/CAOP2011_Shapes/Cont_AAd_CAOP2011.zip">http://www.igeo.pt/produtos/cadastro/caop/download/CAOP2011_Shapes/Cont_AAd_CAOP2011.zip</a></p>
<p>which is in iso-8859-1</p>
<p>then query</p>
<p>"Freguesia" = 'PECHÃO'</p>
<p>it will return 0 results</p>
<p>but the same query will work from the advances search in the attribute table</p> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=287612012-01-26T10:56:33ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>Vector layer data query fails to select objects if SQL text contains not default encoding characters</i> to <i>Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li></ul><p>tested on master</p> QGIS Application - Bug report #4227: Vector layer query fails if SQL text contains not ascii characters (but works in advanced search in the table of attributes)https://issues.qgis.org/issues/4227?journal_id=287622012-01-26T11:24:26ZJürgen Fischerjef@norbit.de
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>Fixed in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/cfcfa0802fabbd42810c6139c00f2dc08f454c18" title="fix #4227">cfcfa0802fabbd42810c6139c00f2dc08f454c18</a>.</p>