pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dan McFadyen <danm@cryptocard.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Odd query behavior
Date: Mon, 15 Mar 2010 13:14:21 -0400
Message-ID: <20344.1268673261@sss.pgh.pa.us> (raw)
In-Reply-To: <BA48DC793F18724D862C27C8F2C131CC620A91@exchange03.cryptocard.internal>
References: <BA48DC793F18724D862C27C8F2C131CC62094F@exchange03.cryptocard.internal>
	<622.1268411385@sss.pgh.pa.us>
	<BA48DC793F18724D862C27C8F2C131CC620A2F@exchange03.cryptocard.internal>
	<18118.1268665439@sss.pgh.pa.us>
	<BA48DC793F18724D862C27C8F2C131CC620A91@exchange03.cryptocard.internal>

"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

view thread (8+ messages)

Message-ID: <20344.1268673261@sss.pgh.pa.us>
Permalink:  ../20344.1268673261@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/20344.1268673261@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, danm@cryptocard.com
  Subject: Re: Odd query behavior
  In-Reply-To: <20344.1268673261@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox