Skip to main content
Question

Specify PostGIS encoding other than current system encoding


mattias
Contributor
Forum|alt.badge.img

I'm trying to use views/tables from a PostGIS database that uses the encoding UTF-8, while my system encoding is ISO-8859-1 / Latin-1.

It works alright until some views named using exotic letters are run through e.g. the LineOnLineOverlayer transformer, which produces a Python Unicode Error (ordinal out of range).

Can I somehow specify in the FME PostGIS reader that the database uses another encoding, or should I submit this behaviour as a bug report?

3 replies

david_r
Celebrity
  • March 6, 2018
Could you post the relevant error messages here? That would help.

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • March 6, 2018

I think if you could please also post (or send to support@safe.com) the workspace that you have that generates this. I also wonder if flipping your python to use 3.x as the interpretter might get your further (python 3 is unicode friendlier than 2). All that said, this exact situation is something we're gearing up to fix once and for all in FME 2019 so your evidence would be very helpful -- and we'd try to advise you on a workaround in the meantime).

Sorry you hit this.


mattias
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • May 21, 2018
fmelizard wrote:

I think if you could please also post (or send to support@safe.com) the workspace that you have that generates this. I also wonder if flipping your python to use 3.x as the interpretter might get your further (python 3 is unicode friendlier than 2). All that said, this exact situation is something we're gearing up to fix once and for all in FME 2019 so your evidence would be very helpful -- and we'd try to advise you on a workaround in the meantime).

Sorry you hit this.

Thanks for your response and tips. Unfortunately I had already changed a lot in the workspace and installed a more recent version of FME and wasn't able to reproduce the problem anymore. If I do encounter the issue again I will make sure to send as much information as possible your way :)

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings