Skip site navigation (1) Skip section navigation (2)

Re: Query with hexadecimal characters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luciano <ldelio(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Query with hexadecimal characters
Date: 2005-01-10 23:05:20
Message-ID: 9595.1105398320@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Luciano <ldelio(at)yahoo(dot)com> writes:
> I am having a problem doing a query with hexadecimal
> characters through ODBC. The hexadecimal characters
> are inside a character filed. It would be something
> like:

> SELECT * FROM MYTABLE WHERE COLUMN1 < 'XXXXXX'

> but instead of the X's there are x'FF' characters...
> The query is accepted, but the result is not
> consistent... it returns an empty result set. Does
> anyone know if I'm missing something?

I suspect you are spitting byte sequences at the backend that are
illegal in the character set encoding you've selected.  Check your
locale and database encoding setup.  C/SQL_ASCII is the best bet
if you want to pretend that you can store any random byte sequence
in a character field.

Plan B, which would probably be better in the long run, is to store
that data in a bytea field instead, and send escaped characters
(ie \\377 rather than an actual FF byte).

			regards, tom lane

In response to

Responses

pgsql-odbc by date

Next:From: LucianoDate: 2005-01-11 02:36:16
Subject: Re: Query with hexadecimal characters
Previous:From: LucianoDate: 2005-01-10 22:10:36
Subject: Query with hexadecimal characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group