Changes between Version 66 and Version 67 of InstallationGuidelines/PostgreSQL

Timestamp:

10/17/13 12:10:46 (11 years ago)

Author:

Fran Boon

Comment:

Locale issues

InstallationGuidelines/PostgreSQL

@@ -262 +262 @@
 == Troubleshooting ==
 
-=== Install ===
+=== Locales ===
 Problem:
 {{{
@@ -285 +285 @@
 rm -f /tmp/pgpass.sql
 }}}
+
+Problem:
+* Trying to import a LATIN1 Shapefile into a UTF-8 table:
+{{{
+Unable to convert data value to UTF-8 (iconv reports "Invalid or incomplete multibyte or wide character"). Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at http://www.postgresql.org/docs/current/static/multibyte.html.
+}}}
+
+Solution:
+* Export in correct encoding
+{{{
+shp2pgsql -s 4326 -W LATIN1 -I mylatin1shapefile.shp public.gis
+}}}
+
+Problem:
+* Want to store data in a LATIN1 table (although this is probably not a good idea!)
+
+Solution:
+{{{
+# View available locales
+locale -a
+# Activate LATIN1 locale
+dpkg-reconfigure locales
+# select en_US ISO-8859-1, OK
+# Check available
+locale -a
+su -c - postgres "createdb -O gis -E LATIN1 mylatin1db -T template0 --lc-collate=en_US.ISO-8859-1 --lc-ctype=en_US.ISO-8859-1"
+}}}
 === Performance ===
  * http://wiki.postgresql.org/wiki/Performance_Optimization