<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Times New Roman \(Body CS\)";
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Georgia",serif;
font-variant:normal !important;
color:windowtext;
text-transform:none;
mso-contextual-alternates:no;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Georgia",serif">Please refer from using other languages, this is an english language list....<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Georgia",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">--<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">Barend Köbben<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Georgia",serif"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal">On 08/04/2018, 11:25, "postgis-users on behalf of Freddy Gonthier" <<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> on behalf of
<a href="mailto:freddy.gonthier@gmail.com">freddy.gonthier@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><a name="_MailOriginalBody">Bonjour,<o:p></o:p></a></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-bookmark:_MailOriginalBody">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.<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-bookmark:_MailOriginalBody">Cordialement,<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">F. Gonthier <o:p>
</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">2018-04-07 21:00 GMT+02:00 <</span><a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank"><span style="mso-bookmark:_MailOriginalBody">postgis-users-request@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">>:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Send postgis-users mailing list submissions to<br>
</span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
</span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://lists.osgeo.org/mailman/listinfo/postgis-users</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
or, via email, send a message with subject or body 'help' to<br>
</span><a href="mailto:postgis-users-request@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users-request@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
<br>
You can reach the person managing the list at<br>
</span><a href="mailto:postgis-users-owner@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users-owner@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Encoding and Collation Question (Aaron Edwards)<br>
2. Re: Encoding and Collation Question<br>
(Darafei Komяpa Praliaskouski)<br>
3. Re: Encoding and Collation Question (Gary Turner)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 6 Apr 2018 22:05:37 +0000<br>
From: Aaron Edwards <</span><a href="mailto:aedwards@b3insight.com"><span style="mso-bookmark:_MailOriginalBody">aedwards@b3insight.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
To: "</span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">" <</span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
Subject: [postgis-users] Encoding and Collation Question<br>
Message-ID:<br>
<</span><a href="mailto:DM5PR1301MB20585A056DB69B2ABE409EFB91BA0@DM5PR1301MB2058.namprd13.prod.outlook.com"><span style="mso-bookmark:_MailOriginalBody">DM5PR1301MB20585A056DB69B2ABE409EFB91BA0@DM5PR1301MB2058.namprd13.prod.outlook.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
<br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
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.<br>
<br>
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.<br>
<br>
Thanks.<br>
<br>
Aaron<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <</span><a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20180406/259dd5f8/attachment-0001.html" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lists.osgeo.org/pipermail/postgis-users/attachments/20180406/259dd5f8/attachment-0001.html</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sat, 07 Apr 2018 11:23:17 +0000<br>
From: Darafei "Komяpa" Praliaskouski <</span><a href="mailto:me@komzpa.net"><span style="mso-bookmark:_MailOriginalBody">me@komzpa.net</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
To: PostGIS Users Discussion <</span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
Subject: Re: [postgis-users] Encoding and Collation Question<br>
Message-ID:<br>
<</span><a href="mailto:CAC8Q8t%2BUxG9WbQTepaPBkUQcvorPhUYxiSKVCEmzJAOL%2BfwASg@mail.gmail.com"><span style="mso-bookmark:_MailOriginalBody">CAC8Q8t+UxG9WbQTepaPBkUQcvorPhUYxiSKVCEmzJAOL+fwASg@mail.gmail.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
If something from one character becomes two or more characters, you're<br>
dealing with multibyte encoding, most likely UTF-8.<br>
<br>
сб, 7 апр. 2018 г. в 1:05, Aaron Edwards <</span><a href="mailto:aedwards@b3insight.com"><span style="mso-bookmark:_MailOriginalBody">aedwards@b3insight.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">>:<br>
<br>
> Hi,<br>
><br>
><br>
><br>
> I’m trying to create a spatial layer in GoeServer using postgis. The<br>
> problem is that there are a few special characters in the name column<br>
> (rivers and streams in New Mexico). In Zuni river, for example, the N has<br>
> a tilde character over it. So the labels are all wonky.<br>
><br>
><br>
><br>
> What Encoding and Collation would prevent this? I tried WIN1252 and<br>
> English_United States.1252, but that prevented me from installing the<br>
> ogr_fdw extension, and that seemed to preclude the use of<br>
> UpdateGeometrySRID(), which I need.<br>
><br>
><br>
><br>
> Thanks.<br>
><br>
><br>
><br>
> Aaron<br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> </span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
> </span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://lists.osgeo.org/mailman/listinfo/postgis-users</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <</span><a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20180407/119732c4/attachment-0001.html" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lists.osgeo.org/pipermail/postgis-users/attachments/20180407/119732c4/attachment-0001.html</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Sun, 8 Apr 2018 00:15:45 +1200<br>
From: Gary Turner <</span><a href="mailto:g@elizr.com"><span style="mso-bookmark:_MailOriginalBody">g@elizr.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
To: </span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
Subject: Re: [postgis-users] Encoding and Collation Question<br>
Message-ID: <</span><a href="mailto:841617ea-d425-d43f-33ae-7e5ab7b920a8@elizr.com"><span style="mso-bookmark:_MailOriginalBody">841617ea-d425-d43f-33ae-7e5ab7b920a8@elizr.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
Content-Type: text/plain; charset="windows-1252"; Format="flowed"<br>
<br>
IIRC, postgres/gis tables are UTF-8 by default. That's probably the<br>
best option to use to avoid hassles, and to be more stable long-term.<br>
<br>
If you are having problems, I suspect that the issue is what encoding<br>
your source data was/is in, and what process you used to import it.<br>
<br>
Can you do it again? What process did you use? Do you know what encoding<br>
it was in?<br>
<br>
<br>
On 07/04/18 10:05, Aaron Edwards wrote:<br>
><br>
> Hi,<br>
><br>
> I’m trying to create a spatial layer in GoeServer using postgis. The<br>
> problem is that there are a few special characters in the name column<br>
> (rivers and streams in New Mexico). In Zuni river, for example, the N<br>
> has a tilde character over it. So the labels are all wonky.<br>
><br>
> What Encoding and Collation would prevent this? I tried WIN1252 and<br>
> English_United States.1252, but that prevented me from installing the<br>
> ogr_fdw extension, and that seemed to preclude the use of<br>
> UpdateGeometrySRID(), which I need.<br>
><br>
> Thanks.<br>
><br>
> Aaron<br>
><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> </span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
> </span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://lists.osgeo.org/mailman/listinfo/postgis-users</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <</span><a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20180408/55f6da7c/attachment-0001.html" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lists.osgeo.org/pipermail/postgis-users/attachments/20180408/55f6da7c/attachment-0001.html</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
</span><a href="mailto:postgis-users@lists.osgeo.org"><span style="mso-bookmark:_MailOriginalBody">postgis-users@lists.osgeo.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
</span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://lists.osgeo.org/mailman/listinfo/postgis-users</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 194, Issue 3<br>
*********************************************<o:p></o:p></span></p>
</blockquote>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
</div>
</body>
</html>