Re: Odd query behavior - Mailing list pgsql-sql

From Tom Lane
Subject Re: Odd query behavior
Date
Msg-id 20344.1268673261@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd query behavior  ("Dan McFadyen" <danm@cryptocard.com>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: "Dan McFadyen"
Date:
Subject: Re: Odd query behavior
Next
From: Eduardo Palafox
Date:
Subject: Please delete my email