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

[strk at refractions.net]

On Thu, Jan 26, 2006 at 12:49:31PM -0000, Mark Cave-Ayland wrote:

> > For background info, see:
> > http://postgis.refractions.net/pipermail/postgis-devel/2005-
> > January/000798.html
> 
> For Tetsushi's case above, the correct handling would be to output SET
> CLIENT_ENCODING TO SJIS with a database encoding of UNICODE. It looks like
> SJIS encoding is only supported under PostgreSQL 8.1 though.

I guess we should ask him about whether CLIENT_ENCODING would
have been enough to fix his problem. IIRC he had problems with
ticks and backslash escaping.

--strk;