Re: How to have ant's <sql> task insert special chars appropriately?

From: "J(dot) Roeleveld" <joost(at)antarean(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to have ant's <sql> task insert special chars appropriately?
Date: 2009-09-23 09:35:03
Message-ID: 200909231135.03128.joost@antarean.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2009-09-23 10:04:09 Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count
Previous Message Richard Huxton 2009-09-23 09:29:02 Re: How to have ant's <sql> task insert special chars appropriately?