> For migration, you should pg_dump- it's not clear from your email whether
> you are doing that. If you typed up some sql in Windows which you want to
> load into postgres, you might try:
> set client_encoding to 'LATIN1';
> at the top of your script.
yes this was how i spotted the problem. If i pg_dump from 7.4 and then
try to load into 8.1 these characters cause errors.
This data was generated on windows though as you say
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.