[GeoNode-users] PostGIS DB Encoding

[Amedeo Fadini]

Hi David,

2016-09-13 10:22 GMT+02:00 David Alda Fernandez de Lezea <dalda at hazi.eus>:
> Hi Daniel,
>
> Thanks for your response. Yeah, I think I’ll have to warn our Users about such problems if they don’t pay attention to that. As we don't have so much data yet I think I'm going to reload the data from scratch.

If you have access to Geonode database there's no need to reload the
data (altought it could be useful to instruct your users :-)) you can
fix the encoding using the convert_from() function in postgresql

https://www.postgresql.org/docs/9.4/static/functions-string.html

Of course you need to prepare a script to run the update query in
every table and every field affected.

I have external data loaded with Foreign data wrappers where I can't
set the client encoding and I'm using this function in my views to
translate the data.

Amefad