Re: Query with hexadecimal characters

Luciano <ldelio@yahoo.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