[postgis-users] Win32 testers required: shp2pgsql with-Wencodingswitch

Mark Cave-Ayland m.cave-ayland at webbased.co.uk
Tue Apr 11 04:17:28 PDT 2006

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Mark Cave-Ayland
> Sent: 11 April 2006 09:15
> To: 'PostGIS Users Discussion'; 'Randy George'
> Subject: RE: [postgis-users] Win32 testers required: shp2pgsql with-
> Wencodingswitch

(I wrote)

> I'm still having some trouble trying to get the data to display correctly
> in
> psql.exe; for example if I do:
> 	Start -> Run -> cmd.exe
> 	chcp 1252
> 	psql -d test
> 	set client_encoding to win1252;
> 	select "NAME" from pr_county;
> ...then psql.exe still doesn't display it correctly. However, pgAdmin III
> handles it without any problems so my guess is that this is a psql.exe
> specific problem - you'd probably have to bring this up on the pgsql lists
> if want to find out the specifics.

I've just found and solved the psql.exe problem as well by looking at the
psql documentation in the "Notes for Windows Users" section
(http://www.postgresql.org/docs/8.1/interactive/app-psql.html#AEN53409). You
also need to change the console font to "Lucida Console" since the standard
raster font apparently doesn't work with ANSI codepages... :)

Now I'm reasonably happy that the encoding is working as it should do under
Win32 - has anyone else managed to test the patched version of shp2pgsql?

Kind regards,


WebBased Ltd
17 Research Way

T: +44 (0)1752 797131
F: +44 (0)1752 791023


This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other

More information about the postgis-users mailing list