Binary

The RDM SQL binary types include BINARY, VARBINARY, and LONG VARBINARY. Binary constants are specified as a sequence of an even number of hexadecimal digits prefixed by "0x" according to the syntax shown below.

binary:
               0x[h]...
create database bintest;
create table bintab(bincol binary(25));
commit;
insert into bintab values 0x0001020304;
select * from bintab;
bincol
0x00010203040000000000000000000000000000000000000000
insert into bintab values 0x000102034;