"Dave Page" <dpage@vale-housing.co.uk> writes:
> select '$123.45'::money
> ERROR: invalid input syntax for type money: "$123.45"
> select '�123.00'::money
> ERROR: invalid input syntax for type money: "�123.00"
So ... what locale are you trying this in?
regards, tom lane