[GeoNode-users] PostGIS DB Encoding

[David Alda Fernandez de Lezea]

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.

Thanks!

Regards,

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.

De: Daniel Victoria [mailto:daniel.victoria at gmail.com] 
Enviado el: lunes, 12 de septiembre de 2016 17:00
Para: David Alda Fernandez de Lezea
CC: geonode-users at lists.osgeo.org
Asunto: Re: [GeoNode-users] PostGIS DB Encoding

Hi David,

From what I understood, you have to choose the correct shapefile encoding the moment you upload the file. If you choose the wrong option, you will get those errors.
I see two ways to fix it. Either edit by hand you wrong entrances in the DB (using PGAdmin) or upload your data again. Your best option will depend on the amount of data you have. But keep in mind that I'm no DB guru so I don't know if there is an automated way to fix all.
Cheers
Daniel

On Mon, Sep 12, 2016 at 7:02 AM, David Alda Fernandez de Lezea <dalda at hazi.eus> wrote:
Hi list,

I’ve just noticed that the DB encoding is set to UTF-8 but my data contains special characters and when viewed in the GeoExplorer I get the texts with �.

From the PGAdmin I see that the data in the tables is wrong, well not wrong but I can see the character �   in the place of some accents or other special characters.

Is there any way to change the encoding of the DB? Do I have to reload the data again?

Thanks in advance.

Regards,
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.

_______________________________________________
geonode-users mailing list
geonode-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geonode-users