04.08.2018 0:49, Chuck Belanger phytotech@... [firebird-support] wrote:

> The above string is created and
> stored in a string just as you see it, but how do I store it in Firebird
> , preferably as-is in a table field?

Use field (VAR)CHAR CHARACTER SET OCTETS. Then "just store" your string.

> I have tried rawbytestring but that truncates the string at the first #0
> character, thus losing the information in the '0' (or some other
> character) that follows.

It is a problem on client side, either in your program on in IBO.

> My only solution right now is to create a new table in a one:many
> relation, such that I can have more than one record per Access code.

It would be a right solution if you made one step further and forget about bitmasks at
all. Just keep access rights as one record per table and user:

CREATE TABLE rights (user INTEGER, table INTEGER, allowed BOOLEAN)

--
WBR, SD.