It's so so annoying. We use Confluence 5.5.2, gosh how I miss version 3 with markups...

Anyway:

Create a page, then

(use Macro Code}
{code:sql}
    select ...
{code}

Save it.

Now try to copy from there to e.g. TextWrangler in Mac. I see an invisible char where should be simple whitespace. And guess what, no programming language accept this!

SQL Error: ORA-00911: invalid character
00911. 00000 -  "invalid character"

Please sort this issue!