Hi Mark,
Currently I am converting my C# polygons to a string of the form
"LINESTRING(x1 y1, ..., xN yN)" which would be the WKT (Well-Known
Text) format.
If I understand your answer correct I could simply convert my C#
polygons to the WKB (Well-Known Binary) format and use BLOB as the
DbType in my SQLiteParameter.
Is that correct?
no, this is not correct.
be very careful: both WKT and WKB are intended as standardized
notations
representing Geometries, but they are not the same of the "binary
internal
BLOB format" supported by SpatiaLite.
anyway you can use the following standard Spatial SQL functions in
order
to correctly serialize / deserialize the internal Geometries format:
to/from WKT notation: ST_AsText() / ST_GeomFromText()
to/from WKB notation: ST_AsBinary() / ST_GeomFromWKB()
bye Sandro
--
Il messaggio e' stato analizzato alla ricerca di virus o
contenuti pericolosi da MailScanner, ed e'
risultato non infetto.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
