[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] load shapefiles in GB2312
From:       Akio Takubo <takubo () saruga-tondara ! net>
Date:       2006-02-22 18:24:21
Message-ID: 20060223032421.7c9ccaf0.takubo () saruga-tondara ! net
[Download RAW message or body]

Hello,

On Wed, 22 Feb 2006 02:13:14 -0800 (PST)
Zhiqiang Zhang <zqzhang01@yahoo.com> wrote:

> For a shapefile in GB2312 encoding, what is the
> correct way to load it into postgis db using
> shp2pgsql?
> 
> The following was attempted but seems to produce a sql
> file with all i18n encoded attribute values as blank
> string "    ".
> 
> shp2pgsql -W GB2312 test roads > roads.sql

 Your exapmle means your dbf's contents convert to utf8 from GB2312. 
roads.sql will have all attributes with utf8.
 What you to do depends on your DB's encoding and your client's locale.
(and your dbf's encoding).

 Thanks,

-- 
    Akio Takubo    from Tokyo, Japan
	takubo@saruga-tondara.net
===================================================

[prev in list] [next in list] [prev in thread] [next in thread]