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

Query with hexadecimal characters

From: Luciano <ldelio(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Query with hexadecimal characters
Date: 2005-01-10 22:10:36
Message-ID: 20050110221036.62433.qmail@web53703.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello!
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?

Thanks in advance!
Luciano


		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2005-01-10 23:05:20
Subject: Re: Query with hexadecimal characters
Previous:From: Jeff EckermannDate: 2005-01-10 21:00:30
Subject: Re: MS Access problem with memos

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