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