Re: Strange errors from 9.2.1 and 9.2.2 (I hope I'm missing something obvious)

On Dec 11, 2012 9:28 PM, "David Gould" <daveg@sonic.net> wrote:
>
> Thank you. I got the example via cut and paste from email and pasted it
> into psql on different hosts. od tells me it ends each line with:
>
>   \n followed by 0xC2 0xA0 and then normal spaces. The C2A0 thing is
>   apparently NO-BREAK SPACE. Invisible, silent, odorless but still deadly.
>
> Which will teach me not to accept text files from the sort of people who
> write code in Word I guess.

It's not just Word... I was bitten by this last week by a WYSIWYG HTML
widget I was using to write some documentation. When I copied the examples
I had created out of said environment during a final technical accuracy
pass and they failed to run in psql, I panicked for a few minutes.

I eventually determined that, rather than just wrapping my code in <pre>
tags, the widget had created &nbsp; entities that were faithfully converted
into Unicode non-breaking spaces in the psql input.