error of loading geometry data from csv file to Spatialite

14 views
Skip to first unread message

usac...@gmail.com

unread,
Jan 2, 2016, 7:26:39 PM1/2/16
to C#-SQLite

I have a database in SQL server 2008 R2. The database has a table with 5 columns and one column is "geometry", like :

  0xE610000001042C1C00000000004033DF60C000000080 ...


I have exported it to a csv file and would like to import it to a database in Spatialite 1.2.1.


I have created a database in Spatialite 1.2.1. The database has a table with the same structure as the one on SQL server.




But, when I imported the csv file to the table, I got error.





I did something wrong ?


I am new to Spatialite.


Thanks !




usac...@gmail.com

unread,
Jan 2, 2016, 7:30:20 PM1/2/16
to C#-SQLite
there is only one row in the csv file. The "geometry" field is very long, which has 65536 characters. If I replaced the long string with a very short one, no error for loading but the table is empty.
Reply all
Reply to author
Forward
0 new messages