Re: How to have ant's task insert special chars appropriately? - Mailing list pgsql-general

From J. Roeleveld
Subject Re: How to have ant's task insert special chars appropriately?
Date
Msg-id 200909231135.03128.joost@antarean.org
Whole thread Raw
In response to Re: How to have ant's task insert special chars appropriately?  (Richard Huxton <dev@archonet.com>)
Responses Re: How to have ant's task insert special chars appropriately?
List pgsql-general
On Wednesday 23 September 2009 11:29:02 Richard Huxton wrote:
> agostonbejo wrote:
> > Hi!
> >
> > What I'm trying to do is to insert some data from a sql file into a
> > postgres DB by calling the <sql> ant task. My problem is that I can't get
> > special characters (even if they can be represented by the standard ASCII
> > charset, such as ä, ö, ü, é, etc.) to be inserted correctly.
>
> Those aren't ASCII.

Actually, they are:
ä = 132
ö = 148
ü = 129
é = 130
See: http://www.ascii.nl
Site is in dutch, but these characters are in the table headed "Extended ASCII
Codes"

But for this to work, the source-file needs to be created using the ASCII
codepage. Not some extension to it.

--
Joost

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How to have ant's task insert special chars appropriately?
Next
From: "Abraham, Danny"
Date:
Subject: Re: PL/PG SQL: select count(*) into from where - does not compute the where cond - returns always total count