Subject RE: [firebird-support] ASCII values
Author Omacht András
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);


select * from table where ascii_val(substring(field from 1 for 1) = 3 and ascii_val(substring(field from 2 for 1) = 1;


From: []
Sent: Friday, March 9, 2018 6:33 AM
Subject: [firebird-support] ASCII values


I have a column char(2) where two ASCII values stored. For example 00000011, 00000001 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?

Hugo Larson

__________ Information from ESET Mail Security, version of virus signature database 17027 (20180309) __________

The message was checked by ESET Mail Security.

[Non-text portions of this message have been removed]