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
> 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
pgsql-odbc by date
|Next:||From: Luciano||Date: 2005-01-11 02:36:16|
|Subject: Re: Query with hexadecimal characters |
|Previous:||From: Luciano||Date: 2005-01-10 22:10:36|
|Subject: Query with hexadecimal characters|