[QGIS-Developer] GeomFromText cuts decimal values, it works, thanks!

Prof. Dr. Jörg Höttges hoettges at fh-aachen.de
Thu Aug 11 06:07:26 PDT 2022


Hi,

many thanks, it works. Until today I could always rely on the fact that the decimal point worked in programming 
languages and databases. So I didn't expect that...

By the way: In SpatialiteGUI everthing worked fine...

Best wishes

Jörg


Am 11.08.2022 um 14:08 schrieb Werner Macho:
> Hi!
> Back on my computer I just tried your exact first example on a fresh created gpkg layer in the database window in QGIS 
> 3.26.1 on a german Version of Windows 10:
> SELECT aswkt(GEOMFROMTEXT('POINT(340178.042761887 5659302.0567476)',25832)) as geom
> and the result is:
> geom
> POINT(340178.042761887 5659302.0567476)
>
> Which version of QGIS on what OS you are on?
> Maybe you set some language settings in the OS (or even maybe in QGIS itself?)
>
> regards
> Werner
>
> On Thu, Aug 11, 2022 at 1:31 PM FH Aachen <hoettges at fh-aachen.de> wrote:
>
>     Hi Werner,
>
>     yes, i did... But it didn't work. Especially not for line objects or polygons: GeomFromText('LineString(350000.123
>     5600000, 350020.456 5600000)'), because the comma ist used to seperate the coordinate value pairs.
>
>     Regards
>     Jörg
>
>     11.08.2022 12:46:07 Werner Macho via QGIS-Developer <qgis-developer at lists.osgeo.org>:
>
>     > Hi,
>     > Have you tried to substitute point with comma?
>     > Worth a try.
>     >
>     > Regards werner
>     > _______________________________________________
>     > QGIS-Developer mailing list
>     > QGIS-Developer at lists.osgeo.org
>     > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220811/be26de86/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5991 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220811/be26de86/attachment.bin>


More information about the QGIS-Developer mailing list