[GeoNode-users] PostGIS DB Encoding

[David Alda Fernandez de Lezea]

Hi Amedeo,

Thanks for your response! I didn't know about this function, I'll take a look at it.

Thanks!

Agur bero bat,


David Alda Fernández de Lezea
Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.
dalda at hazi.eus | www.hazi.eus
T 945 003 240 – M 627 923 170 – F 945 003 290 
Hazi | Granja Modelo de Arkaute s/n | 01192 Arkaute – Araba
 
*********************  LEGE OHARRA   *******************   AVISOLEGAL   *******************   DISCLAIMER   *****************************
Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.
Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.
This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.

-----Mensaje original-----
De: geonode-users [mailto:geonode-users-bounces at lists.osgeo.org] En nombre de Amedeo Fadini
Enviado el: martes, 13 de septiembre de 2016 13:07
Para: geonode-users at lists.osgeo.org
Asunto: Re: [GeoNode-users] PostGIS DB Encoding

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
_______________________________________________
geonode-users mailing list
geonode-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geonode-users