[postgis-users] re: shp2sql and UTF8 question on Windows

[Armin Burger]

Maybe the support for iconv was not compiled into the Windows binaries. 
You could try run iconv on the SQL file before loading it. An iconv.exe 
for Windows is available at

ftp://ftp.gnu.org/gnu/libiconv/libiconv-1.9.1.bin.woe32.zip
(you need also 
ftp://ftp.gnu.org/gnu/gettext/gettext-runtime-0.13.1.bin.woe32.zip)

Armin


Randy George wrote:
> Hi,
> 
>  
> 
> I am using postgresql-8.1.2-1 with PostGIS 1.1.1 on a Windows 2003 OS 
> installed using the installer from http://www.webbased.co.uk/mca/
> 
>  
> 
> I have a database created with ENCODING = 'UTF8'
> 
>  
> 
> I am then using the shp2sql translator to create a table from a shp file 
> with a municipio named Manat¡
> 
> ¡ = hex A1
> 
>  
> 
> When I attempt to load the resulting sql file into the table I get this 
> error:
> 
>  
> 
> psql:test.sql:15: ERROR:  invalid UTF-8 byte sequence detected near byte 
> 0xa1
> 
> CONTEXT:  COPY county, line 1, column NAME: "Manatí"
> 
> ROLLBACK
> 
>  
> 
> When I try to use the –W parameter I get this message:
> 
> WARNING: the -W switch will have no effect. UTF8 disabled at compile time
> 
>  
> 
> Is there a way to get around this?
> 
>  
> 
> Thanks
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users