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

[Akio Takubo]

Hi,

 I've tryed your shp2pgsql for shape file with japanese character.
It works fine with "-W cp932" option in my WInXP pc. There is no
problem conversion to UTF-8. CP932 is an encoding with MS windows 
japanese edition.
 I hope this report help you.

Thanks,  

 Akio Takubo

On Tue, 11 Apr 2006 12:17:28 +0100
"Mark Cave-Ayland" <m.cave-ayland at webbased.co.uk> wrote:

> 
> > -----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,
> 
> Mark.
> 
> ------------------------
> WebBased Ltd
> 17 Research Way
> Plymouth
> PL6 8BT
> 
> T: +44 (0)1752 797131
> F: +44 (0)1752 791023
> 
> http://www.webbased.co.uk   
> http://www.infomapper.com
> http://www.swtc.co.uk  
> 
> 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
> person.
>