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

[Markus Schaber]

Hi, Strk,

strk at refractions.net 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.

AFAIK, SJIS has a different symbol on the ascii position of \ so the
backslashes output by shp2pgsql will not be recognized by postgresql,
leading to strange effects.

Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org