Skip to main content
  • EN
Hi,

 

 

Does anyone know whether it is possible to write UTF-8 data to Sqlite spatial?

 

 

You get the option to specify encoding when using the Spatialite writer but not the Sqlite spatial writer?

 

 

Any ideas?

 

 

Thanks
Hi,

 

 

why not do a small test? I'd be very surprised if it didn't support UTF-8.

 

 

David
Hi David

 

 

I have run a small test with some data with utf-8 Greek characters and these are not reproduced correctly when using the standard SQLite spatial writer. I'm using FME desktop 2013 sp2. Does anyone know if there is a workaround for this.

 

 

Thanks

 

 

James
Hi,

 

 

are you using the "Spatialite" or the "SQLite Spatial (FDO)" writer?

 

 

I suspect the Spatialite writer is newer. It will let also you specify the character set.

 

 

David
Hi David,

 

 

I have run tests with both,

 

 

Spatialite will create data in UTF-8, but it's structure is different and cannot be read by applications such as MapInfo pro

 

 

SQLite spatial can be read by MiPro, but the writer seems to be unable to write with UTF-8, as far as I can tell, unless anyopne knows of a work around

 

 

I guess that's where I am,

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.