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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Luciano | 2005-01-11 02:36:16 | Re: Query with hexadecimal characters |
Previous Message | Luciano | 2005-01-10 22:10:36 | Query with hexadecimal characters |