Subject Re: [IB-Architect] System table change
Author Dalton Calford
Hi Oliver,

The only thing that I would want to be able to do is extract any element
out of the binary array and manipulate it.
That includes casting it to a ASCII equivalent, or XOR'ing it with
another binary element.
Left and Right Shift Mathmatics as well. (although multiplying or
dividing it by 2 works just as well)
The thing here is, anything we do should be able to be done in
SP/Trigger code.
If we use the OCTET subtype, we are limiting our manipulation to client
side unless we also create a series of UDF's to handle the manipulation.

I do not mind the idea of making the UDF's as long as we all agree to
the format and what exactly needs to be done.

best regards


Olivier Mascia wrote:
> > And good idea of using subtypes for VARCHAR and CHAR fields that
> > can indicate short binary data. This enables new data type aliases:
> > VARBINARY(n) and BINARY(n) (someone asked about octet(4) for ip
> > adresses?).
> > Unfortunately, this can introduce incompatibility when software
> > that assumes every VAR/CHAR is textual tries to convert it to text.
> Works perfectly well for storing/retrieving and moving around (in
> local variables in triggers and stored procedures) things like IP
> addresses in network format.
> I also routinely use CHAR(8) CHARACTER SET OCTETS for temporary
> storage (local variables) of RDB$DB_KEYs.
> Is there really a need to invent a BINARY ?
> Is it part of any SQL standard ?
> Are there reasons why the above should not work ?
> - --
> Olivier Mascia, om@..., Senior Software Engineer
> T.I.P. Group S.A.,, Director
> Version: PGP Personal Privacy 6.5.8
> XHT3KCOtzgdW2wMH/zxc3bVz+8VDTs07Yb4OA0H4My/8wehzpCJN/VhhY9vi/2sI
> Tf6qYkp5IWjUAaNkbuMowkYmPaNc0dQAU75VVWHoC6928i3W4DqGszq00bUbzlii
> yhO4/LyOG9flm2njATqgEZKXVvfhV5z63Zr1He4HZCTs6uxZ3JGcxvZxiWWe1Fyf
> XJ3UUbDTu8pqov5WxrfMfhOcLA3+JF6y9ZErLtH4ADHJ8IltIoaR5YYAcVWVoG7G
> 0IC5YFX9vzLl3y75PsOYacwqfmw/u2x2OVRLVQnuI99VLtsuX5ukBA==
> =5W6Z
> To unsubscribe from this group, send an email to: