"Dan McFadyen" <d...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql