Re: [postgis-users] postgis-users Digest, Vol 194, Issue 4

[Nicolas Ribot]

On 9 April 2018 at 18:02, Aaron Edwards  wrote:

> Hi All,
>
> Thanks for replying.
>
> The data is being read from SQL Server, where it is encoded in Latin1.
> I'm reading it from SQL Server, and writing it to postgis using a .NET
> process.  I'm not doing anything special to convert from one character set
> to the other, so maybe that's the problem.
>
> Aaron
>
> Hi,

Then, you should set the PGCLIENTENCODING environment variable to
'LATIN1',  either at the system level or when initializing connection.
(https://www.postgresql.org/docs/current/static/multibyte.html)

Nicolas
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] postgis-users Digest, Vol 194, Issue 4

[Aaron Edwards]

Hi All,

Thanks for replying.

The data is being read from SQL Server, where it is encoded in Latin1.  I'm 
reading it from SQL Server, and writing it to postgis using a .NET process.  
I'm not doing anything special to convert from one character set to the other, 
so maybe that's the problem.

Aaron


-Original Message-
From: postgis-users  On Behalf Of 
postgis-users-requ...@lists.osgeo.org
Sent: Sunday, April 08, 2018 1:00 PM
To: postgis-users@lists.osgeo.org
Subject: postgis-users Digest, Vol 194, Issue 4

Send postgis-users mailing list submissions to
postgis-users@lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-requ...@lists.osgeo.org

You can reach the person managing the list at
postgis-users-ow...@lists.osgeo.org

When replying, please edit your Subject line so it is more specific than "Re: 
Contents of postgis-users digest..."


Today's Topics:

   1. Re: postgis-users Digest, Vol 194, Issue 3 (Freddy Gonthier)
   2. Re: postgis-users Digest, Vol 194, Issue 3 (b.j.kob...@utwente.nl)


--

Message: 1
Date: Sun, 8 Apr 2018 11:24:45 +0200
From: Freddy Gonthier 
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] postgis-users Digest, Vol 194, Issue 3
Message-ID:

Content-Type: text/plain; charset="utf-8"

Bonjour,

Il faut que l’application qui ouvre le fichier avec les données sources le 
fasse avec le même code page que celui qui a été utiliser pour écrire les 
enregistrements du fichier source. Attention, il existe des limites connues 
comme un fichier source écrit avec plusieurs code page, ou encore, les 
caractères du code page du fichier sources ne sont pas tous transposables vers 
le code page de la base données.

Cordialement,

F. Gonthier

2018-04-07 21:00 GMT+02:00 :

> Send postgis-users mailing list submissions to
> postgis-users@lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> postgis-users-requ...@lists.osgeo.org
>
> You can reach the person managing the list at
> postgis-users-ow...@lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific 
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
>1. Encoding and Collation Question (Aaron Edwards)
>2. Re: Encoding and Collation Question
>   (Darafei Komяpa Praliaskouski)
>3. Re: Encoding and Collation Question (Gary Turner)
>
>
> --
>
> Message: 1
> Date: Fri, 6 Apr 2018 22:05:37 +
> From: Aaron Edwards 
> To: "postgis-users@lists.osgeo.org" 
> Subject: [postgis-users] Encoding and Collation Question
> Message-ID:
>  namprd13.prod.outlook.com>
>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> I'm trying to create a spatial layer in GoeServer using postgis.  The 
> problem is that there are a few special characters in the name column 
> (rivers and streams in New Mexico).  In Zuni river, for example, the N 
> has a tilde character over it.  So the labels are all wonky.
>
> What Encoding and Collation would prevent this?  I tried WIN1252 and 
> English_United States.1252, but that prevented me from installing the 
> ogr_fdw extension, and that seemed to preclude the use of 
> UpdateGeometrySRID(), which I need.
>
> Thanks.
>
> Aaron
>
> -- next part -- An HTML attachment was 
> scrubbed...
> URL:  attachments/20180406/259dd5f8/attachment-0001.html>
>
> --
>
> Message: 2
> Date: Sat, 07 Apr 2018 11:23:17 +
> From: Darafei "Komяpa" Praliaskouski 
> To: PostGIS Users Discussion 
> Subject: Re: [postgis-users] Encoding and Collation Question
> Message-ID:
>  emzjaol+fw...@mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> If something from one character becomes two or more characters, you're 
> dealing with multibyte encoding, most likely UTF-8.
>
> сб, 7 апр. 2018 г. в 1:05, Aaron Edwards :
>
> > Hi,
> >
> >
> >
> > I’m trying to create a spatial layer in GoeServer using postgis.  
> > The problem is that there are a few special characters in the name 
> > column (rivers and streams in New Mexico).  In Zuni river, for 
> > example, the N
> has
> > a tilde character over it.  So the labels are all wonky.
> >
> >
> >
> > What Encoding and Collation would prevent this?  I tried WIN1252 and 
> > English_United States.1252, but that prevented me from installing 
> > the ogr_fdw extension, and that seemed to preclude the use of 
> > UpdateGeometrySRID(), which I need.
> >
> >
> >
> > Thanks.
> >
> >
> >
> > Aaron
>