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:
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
08.03.2018 12:23, jonatan.laurit...@yahoo.dk wrote:
>
> I have Firebird 2.1 dialect 1/charset NONE database and I am moving it
> to Firebird to get all the performance improvements (64 bit,
> multi-process capabilities, etc.). Move to dialect 3/charset UTF8 is
> quite involved, I am trying to
08.03.2018 12:44, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Just wanted to know if there is available free (of charge) C++/C compiler for
> Firebird 3
> UDFs on Windows - 32 bit and 64 bit?
GCC (MinGW).
--
WBR, SD.
Hello!
I have Firebird 2.1 dialect 1/charset NONE database and I am moving it to
Firebird to get all the performance improvements (64 bit, multi-process
capabilities, etc.). Move to dialect 3/charset UTF8 is quite involved, I am
trying to do this, of course, but as fallback option I would like