[QGIS-Developer] GeomFromText cuts decimal values

Andrea Giudiceandrea andreaerdna at libero.it
Thu Aug 11 07:25:27 PDT 2022


> *Prof. Dr. Jörg Höttges*hoettges at fh-aachen.de 
> <mailto:qgis-developer%40lists.osgeo.org?Subject=Re%3A%20%5BQGIS-Developer%5D%20GeomFromText%20cuts%20decimal%20values&In-Reply-To=%3C432c9575-39fc-7963-6015-facdd2d3da11%40fh-aachen.de%3E>
> /Thu Aug 11 03:24:32 PDT 2022/
> ------------------------------------------------------------------------
>      SELECT aswkt(GEOMFROMTEXT('POINT(340178.042761887 5659302.0567476)',25832)) as geom
>
> i get
>
>      geom
>      POINT(340178 5659302)

Hi,
I've just tried using QGIS 3.22.9 and QGIS 3.26.1 on Windows 10 and 
Ubuntu 22.04 (Italian) with "Italian Italy (it_IT)" locale (a locale for 
which the comma is the decimal separator): the statement

SELECT aswkt(GEOMFROMTEXT('POINT(340178.042761887 
5659302.0567476)',25832)) as geom

outputs

geom
POINT(340178.042761887 5659302.0567476)

while the statement

SELECT aswkt(GEOMFROMTEXT('POINT(340178,042761887 
5659302,0567476)',25832)) as geom

outputs

geom
NULL


Best regards.

Andrea Giudiceandrea
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220811/3cdf88c0/attachment-0001.htm>


More information about the QGIS-Developer mailing list