Skip to main content
Question

Spatialite and encoding

  • August 22, 2013
  • 2 replies
  • 21 views
J
I have some shapefiles which FME reads and then writes the data to PostGIS. I have added a Spatialite writer to the workspace as well as I have some users that need file based access to the data.

 

 

The data loads into PostGIS fine and I can see the Norwegian characters æ, ø and å fine.

 

 

But the data loads into Spatialite with these characters replaced.

 

 

The data is writen to PostGIS and spatialite in the same workspace, so it goes through the same transformers etc.

 

 

Can anyone suggest how I can fix this?
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.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • August 22, 2013
Hi,

 

 

Have you tried setting the character encoding setting in the writer parameters?
J
  • jamesstott
  • Author
  • August 22, 2013
Thanks for the reply.

 

 

I set the encoding of the source data (iso-8859-1) and the output dataset (utf-8) and it worked. 

 

 

I was almost certain I had done this yesterday and it didnt work. 

 

 

Well today it works. Thanks again.

 

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.