Thanks, you were right - actually the problem was somewhere else. During the
build I had the sql files copied over to another location, feeding them to
ant's <filterchain> -- and it was there actually where the encodings got
mixed up.
(Needless to say, I was looking at the original file and thought it was the
<sql> or PostGres that messed something up.)
Anyway, after correcly copying over the file, the one with the ISO-8859-1
could be used perfectly. (I suppose the UTF-8 could have as well, but I
didn't try it once this one worked.)
Thanks,
Agoston
Richard Huxton wrote:
>
> Check again - something isn't right. Take the original ,sql file, save
> it as UTF8 and add a line at the top "set client_encoding=utf8;"
>
> Run this through psql and it should work fine. If not, then the database
> isn't in utf8 after all.
>
> Assuming it works, then something in your java setup isn't correct.
>
> --
> Richard Huxton
> Archonet Ltd
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
View this message in context:
http://www.nabble.com/How-to-have-ant%27s-%3Csql%3E-task-insert-special-chars-appropriately--tp25530663p25748884.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.