Question

Does SQLite spatial writer support UTF-8 characters?

J
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

4 replies

david_r
Rank
Userlevel 4
Hi,

 

 

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

 

 

David
J
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
david_r
Rank
Userlevel 4
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
J
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

28,669
Posts
109,357
Replies
36,531
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.