--0016e64be86293195d04798e7371
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
On Fri, Nov 27, 2009 at 3:45 AM, Brian Modra <epailty [at] googlemail.com> wrote=
:
> 2009/11/26 Melanie Hofmann <helpmisterx [at] googlemail.com>:
> > Hello,
> >
> > I'm a very big problem. I want to load shapefiles in a postgresql with
> > shp2pgsql and psql. So i create the statement on a windows DOS console.=
I
> > get below error FEHLER: ungültige Byte-Sequenz für Kodierung UTF8
> 0xd627.
> >
> > My Client_encoding is
> >
> > template_postgis=3D# SHOW CLIENT_ENCODING;
> > client_encoding
> > -----------------
> > UTF8
> > (1 row)
> >
> > and my database encoding is also UTF8, only my shapefile is not in UTF8=
..
>
> Melanie, I am posting this in the off-chance that it may help you. I
> faced the same problem as you about 3 years ago, and have not thought
> about it since. I put this at the top of the SQL file that I generate
> for inserting into the database (other SQLs generated by shp2sql)
>
> set client_encoding to 'LATIN1';
>
Or try 'ASCII' if 'LATIN1' doesn't work.
>
> > I make a few trails to change the client encoding, but nothing realy
> works.
> >
> > What can I do?
> > Can anybody help me?
> >
> > Thanks.
> >
> > Regards MisterX
> >
>
>
>
> --
> Brian Modra Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa
> http://www.zwartberg.com/
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Cheers,
Mark Guadalupe
Mobile: +64 21 973 677
Skype: markguadalupe
ICQ: 162553538
Yahoo ID: mak1e
Twitter: mak1e
http://is.gd/kajL
The information in this email and any attachments is confidential. This
information may be subject to legal, professional, or other privilege. It
must not be disclosed to any person without our authority. If you are not
the intended recipient you are not authorised to and must not disclose,
copy, distribute, or retain this message or any part of it. Please return
this message to the sender immediately and delete any and all copies from
your system.
--0016e64be86293195d04798e7371
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<br><br><div class=3D"gmail_quote">On Fri, Nov 27, 2009 at 3:45 AM, Brian M=
odra <span dir=3D"ltr"><<a href=3D"mailto:epailty [at] googlemail.com">epailt=
y [at] googlemail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote"=
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
2009/11/26 Melanie Hofmann <<a href=3D"mailto:helpmisterx [at] googlemail.com=
">helpmisterx [at] googlemail.com</a>>:<br>
<div class=3D"im">> Hello,<br>
><br>
> I'm a very big problem. I want to load shapefiles in a postgresql =
with<br>
> shp2pgsql and psql. So i create the statement on a windows DOS console=
.. I<br>
> get below error FEHLER:=A0 ungültige Byte-Sequenz für Kodierung UT=
F8 0xd627.<br>
><br>
> My Client_encoding is<br>
><br>
> template_postgis=3D# SHOW CLIENT_ENCODING;<br>
> =A0client_encoding<br>
> -----------------<br>
> =A0UTF8<br>
> (1 row)<br>
><br>
> and my database encoding is also UTF8, only my shapefile is not in UTF=
8.<br>
<br>
</div>Melanie, I am posting this in the off-chance that it may help you. I<=
br>
faced the same problem as you about 3 years ago, and have not thought<br>
about it since. I put this at the top of the SQL file that I generate<br>
for inserting into the database (other SQLs generated by shp2sql)<br>
<br>
set client_encoding to 'LATIN1';<br></blockquote><div><br></div><di=
v>Or try 'ASCII' if 'LATIN1' doesn't work.</div><div>=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex;">
<div class=3D"im"><br>
> I make a few trails to change the client encoding, but nothing realy w=
orks.<br>
><br>
> What can I do?<br>
> Can anybody help me?<br>
><br>
> Thanks.<br>
><br>
> Regards MisterX<br>
><br>
<br>
<br>
<br>
</div>--<br>
Brian Modra =A0 Land line: +27 23 5411 462<br>
Mobile: +27 79 69 77 082<br>
5 Jan Louw Str, Prince Albert, 6930<br>
Postal: P.O. Box 2, Prince Albert 6930<br>
South Africa<br>
<a href=3D"http://www.zwartberg.com/" target=3D"_blank">http://www.zwartber=
g.com/</a><br>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-admin mailing list (<a href=3D"mailto:pgsql-admin [at] postgresql=
..org">pgsql-admin [at] postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>--=A0<br>Cheers,<br>Mar=
k Guadalupe<br><br>Mobile: +64 21 973 677<br>Skype: markguadalupe<br>ICQ: 1=
62553538<br>Yahoo ID: mak1e<br>Twitter: mak1e<br><a href=3D"http://is.gd/ka=
jL">http://is.gd/kajL</a><br>
<br>The information in this email and any attachments is confidential. This=
information may be subject to legal, professional, or other privilege. It =
must not be disclosed to any person without our authority. If you are not t=
he intended recipient you are not authorised to and must not disclose, copy=
, distribute, or retain this message or any part of it. Please return this =
message to the sender immediately and delete any and all copies from your s=
ystem.
--0016e64be86293195d04798e7371--
