<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
Am Donnerstag, den 25.11.2010, 11:16 -0300 schrieb Ricardo Bayley:<BR>
<BLOCKQUOTE TYPE=CITE>
Hi folks,
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
I am trying to export my tables from postgis. I am trying to use OGR2OGR
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
How can I set the encoding ? I have tried setting the options in the connection string, but no luck
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
PG:dbname='myDbname' host='localhost' port='5432' user='usrname' password='pass' options='--client_encoding=LATIN1'
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
Regards
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
Ricardo
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<PRE>
_______________________________________________
Qgis-user mailing list
<A HREF="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A>
<A HREF="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</A>
</PRE>
</BLOCKQUOTE>
<BR>
Hi Ricardo<BR>
<BR>
i just had the same prob yesterday but only the other way around (wanted to load stuff to a PG DB). i found that the right syntax should be something like: <BR>
<BR>
<BLOCKQUOTE>
ogr2ogr --config PGCLIENTENCODING WIN1252 -f "PostgreSQL" PG:"host=somehost user=someuser dbname=someDB password=somepass port=someport" path2someDB -a_srs EPSG:9999<BR>
<BR>
</BLOCKQUOTE>
so maybe you should shuffle around a bit the options? hope that helps!<BR>
Cheers Johannes
</BODY>
</HTML>