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
Question
Does SQLite spatial writer support UTF-8 characters?
Hi,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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,