2009/11/26 Melanie Hofmann <helpmisterx@xxxxxxxxxxxxxx>: > 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=# 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'; > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
