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

[Nicolas Ribot]

On 9 April 2018 at 18:02, Aaron Edwards <aedwards at b3insight.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180409/8988036e/attachment.html>