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@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
