Re: Odd query behavior

"Dan McFadyen" <danm@cryptocard.com> writes:
> Now, the interesting part is for all I can tell, there are no special
> characters in the field. Unless the latest version of Pgadmin (1.10.1 or
> 1.10.2) hides this from the UI, either that or it's some character that
> renders into a similar glyph as ASCII.

> Is there any way to force hex/binary in a SQL statement? 

Huh.  Try pg_dump'ing the table and then searching the file for any
bytes with high bit set.

It's possible that Finnish locale sorts some of the plain-ASCII
characters differently than C locale would, but I don't know of
a reason for that to break anything.
        regards, tom lane