Hi Hugo!
If i understood well, you need this (tested on Fb2.5.8):
select * from table where field = ascii_char(3) || ascii_char(1);
or
select * from table where ascii_val(substring(field from 1 for 1) = 3 and
ascii_val(substring(field from 2 for 1) = 1;
András
From: firebird-support@yahoogroups.com
[mailto:firebird-supp...@yahoogroups..com]
Sent: Friday, March 9, 2018 6:33 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] ASCII values
Hello,
I have a column char(2) where two ASCII values stored. For example 0011,
0001 are stored as (3,1).
When I do a select I dont get any result because the result is not
alphanumeric. 3 is ETX and 1 is NUL.
I can get the values programmatically but I want to do bit comparison with sql
query.
Anyone might know how?
Thx,
Hugo Larson
__ Information from ESET Mail Security, version of virus signature
database 17027 (20180309) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-text portions of this message have been removed]