Re: [firebird-support] Storing a byte array in Firebird
On 26-10-2019 22:46, blackfalconsoftw...@outlook.com [firebird-support] wrote: > I need to store a byte array for the security aspect of the application > I am developing. > > > Would you simply store it in a field defined with the BLOB type or use > the ARRAY type if one knew the length of the array? In Firebird 3 and earlier you can use `CHAR(n) CHARACTER SET OCTETS` (which will be padded with 0x00 up to the declared length) or `VARCHAR(n) CHARACTER SET OCTETS`. For byte arrays this allows a maximum length of 32767 bytes (32765 for `VARCHAR`). Firebird 4 introduces aliases `BINARY(n)` and `VARBINARY(n)` for these types. For longer values, use a `BLOB SUB_TYPE BINARY`. Don't use an array type, they are badly supported in drivers and tools, and even within Firebird support is minimal in DSQL/PSQL. Mark -- Mark Rotteveel
Re: [firebird-support] Storing a byte array in Firebird
26.10.2019 22:46, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Would you simply store it in a field defined with the BLOB type or use the > ARRAY type if > one knew the length of the array? (VAR)BINARY or BLOB depending on length estimation. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Storing a byte array in Firebird
Hello... I need to store a byte array for the security aspect of the application I am developing. Would you simply store it in a field defined with the BLOB type or use the ARRAY type if one knew the length of the array? Thank you... Steve Naidamast Sr. Software engineer