[postgis-users] Encoding and Collation Question

[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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180406/259dd5f8/attachment.html>