Does SQLite spatial writer support UTF-8 characters?

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,