[postgis-users] shp2pgsql and multibyte shape files

[Jorg Heymans]

strk at refractions.net wrote:
> 
> 
> Documentation contributions are welcome.
> --strk;

attached.

Thanks
Jorg
-------------- next part --------------
--- postgis.html.orig	2005-08-07 02:18:34.000000000 +0200
+++ postgis.html	2005-08-19 13:50:51.000000000 +0200
@@ -237,7 +237,7 @@
 # make install</pre></td></tr></table><p>The loader is called <tt class="filename">shp2pgsql</tt> and converts
       ESRI Shape files into SQL suitable for loading in PostGIS/PostgreSQL.
       The dumper is called <tt class="filename">pgsql2shp</tt> and converts PostGIS
-      tables (or queries) into ESRI Shape files.</p></div></div><div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="id2495371"></a>Chapter 3. Frequently Asked Questions</h2></div></div><div></div></div><div class="qandaset"><dl><dt>3.1. <a href="#id2495379">What kind of geometric objects can I store?</a></dt><dt>3.2. <a href="#id2495399">How do I insert a GIS object into the database?</a></dt><dt>3.3. <a href="#id2495495">How do I construct a spatial query?</a></dt><dt>3.4. <a href="#id2495560">How do I speed up spatial queries on large tables?</a></dt><dt>3.5. <a href="#id2495642">Why aren't PostgreSQL R-Tree indexes supported?</a></dt><dt>3.6. <a href="#id2495695">Why should I use the AddGeometryColumn()
+      tables (or queries) into ESRI Shape files.</p><p>For multibyte support you should set the <tt class="varname">USE_ICONV</tt> variable in <tt class="filename">Makefile.config</tt> (or in the environment).</p></div></div><div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="id2495371"></a>Chapter 3. Frequently Asked Questions</h2></div></div><div></div></div><div class="qandaset"><dl><dt>3.1. <a href="#id2495379">What kind of geometric objects can I store?</a></dt><dt>3.2. <a href="#id2495399">How do I insert a GIS object into the database?</a></dt><dt>3.3. <a href="#id2495495">How do I construct a spatial query?</a></dt><dt>3.4. <a href="#id2495560">How do I speed up spatial queries on large tables?</a></dt><dt>3.5. <a href="#id2495642">Why aren't PostgreSQL R-Tree indexes supported?</a></dt><dt>3.6. <a href="#id2495695">Why should I use the AddGeometryColumn()
           function and all the other OpenGIS stuff?</a></dt><dt>3.7. <a href="#id2495743">What is the best way to find all objects within a radius of
           another object?</a></dt><dt>3.8. <a href="#id2495795">How do I perform a coordinate reprojection as part of a
           query?</a></dt></dl><table border="0" summary="Q and A Set"><col align="left" width="1%"><tbody><tr class="question"><td align="left" valign="top"><a name="id2495379"></a><a name="id2495381"></a><b>3.1.</b></td><td align="left" valign="top"><p>What kind of geometric objects can I store?</p></td></tr><tr class="answer"><td align="left" valign="top"><b></b></td><td align="left" valign="top"><p>You can store point, line, polygon, multipoint, multiline,