Re: [Firebird-devel] Return type of DECRYPT
On 09-05-2021 18:25, Mark Rotteveel wrote: On 09-05-2021 18:02, Dimitry Sibiryakov wrote: 09.05.2021 18:00, Mark Rotteveel wrote: On 09-05-2021 17:54, Dimitry Sibiryakov wrote: 09.05.2021 17:48, Mark Rotteveel wrote: However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is subtype only. No, VARBINARY is an alias for VARCHAR CHARACTER SET OCTETS. Oops, that may be a bug then. I created https://github.com/FirebirdSQL/firebird/issues/6797 RSA_DECRYPT has the same problem. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Return type of DECRYPT
On 09-05-2021 18:02, Dimitry Sibiryakov wrote: 09.05.2021 18:00, Mark Rotteveel wrote: On 09-05-2021 17:54, Dimitry Sibiryakov wrote: 09.05.2021 17:48, Mark Rotteveel wrote: However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is subtype only. No, VARBINARY is an alias for VARCHAR CHARACTER SET OCTETS. Oops, that may be a bug then. I created https://github.com/FirebirdSQL/firebird/issues/6797 Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Return type of DECRYPT
09.05.2021 18:00, Mark Rotteveel wrote: On 09-05-2021 17:54, Dimitry Sibiryakov wrote: 09.05.2021 17:48, Mark Rotteveel wrote: However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is subtype only. No, VARBINARY is an alias for VARCHAR CHARACTER SET OCTETS. Oops, that may be a bug then. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Return type of DECRYPT
On 09-05-2021 17:54, Dimitry Sibiryakov wrote: 09.05.2021 17:48, Mark Rotteveel wrote: However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is subtype only. No, VARBINARY is an alias for VARCHAR CHARACTER SET OCTETS. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Return type of DECRYPT
09.05.2021 17:48, Mark Rotteveel wrote: However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is subtype only. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Return type of DECRYPT
According the Firebird 4.0 Release Notes, the return type of the DECRYPT and ENCRYPT functions is: """ Functions return BLOB when the first argument is blob and varbinary for all text types. """ However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a non-BLOB type, is that intentional, or is this a bug? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel