Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux