[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