[GeoNode-users] PostGIS DB Encoding

[Daniel Victoria]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20160912/8889cd27/attachment.html>