Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Adriano dos Santos Fernandes
On 07/09/2020 10:19, Alex Peshkoff via Firebird-devel wrote: > > May be something more generic - when we meet an expression node that > casts from binary to some charset all it's children as deep as > expression evaluation continues should cast to that same charset before > transliterating to bina

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Dimitry Sibiryakov
07.09.2020 15:19, Alex Peshkoff via Firebird-devel wrote: May be something more generic - when we meet an expression node that casts from binary to some charset all it's children as deep as expression evaluation continues should cast to that same charset before transliterating to binary? Jus

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 22:35, Adriano dos Santos Fernandes wrote: On 05/08/2020 12:48, Ivan Přenosil wrote: In FB2.5 I sometimes construct exception messages with newline like this   EXCEPTION E_ERROR 'msg-á' || x'0A0D' || 'msg-é'; In FB3 and FB4 it can cause error   Statement failed, SQLSTATE = 22000

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Dimitry Sibiryakov
07.09.2020 12:58, Alex Peshkoff via Firebird-devel wrote: The result remains almost the same: You forgot to recode the script into 1250 as well. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 17:49, Ivan Přenosil wrote: Dne 04.09.2020 v 12:57 Alex Peshkoff via Firebird-devel napsal(a): Not reproduced: SQL> CREATE DATABASE '~/testDB.fdb' USER 'SYSDBA' PASSWORD 'masterkey' DEFAULT CHARACTER SET WIN1250; SQL> CREATE EXCEPTION  E_ERROR 'err'; SQL> SQL> set term ^; SQL>

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 14:04, Dimitry Sibiryakov wrote: 04.09.2020 12:57, Alex Peshkoff via Firebird-devel wrote: Not reproduced:   You forgot "set names win1250" at the beginning of the script. The result remains almost the same: Statement failed, SQLSTATE = HY000 exception 1 -E_ERROR -msg-� msg-�

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-04 Thread Adriano dos Santos Fernandes
On 05/08/2020 12:48, Ivan Přenosil wrote: > In FB2.5 I sometimes construct exception messages with newline like this >   EXCEPTION E_ERROR 'msg-á' || x'0A0D' || 'msg-é'; > > In FB3 and FB4 it can cause error >   Statement failed, SQLSTATE = 22000 >   Malformed string >   -At block line: 4, col: 3 >

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-04 Thread Ivan Přenosil
Dne 04.09.2020 v 12:57 Alex Peshkoff via Firebird-devel napsal(a): Not reproduced: SQL> CREATE DATABASE '~/testDB.fdb' USER 'SYSDBA' PASSWORD 'masterkey' DEFAULT CHARACTER SET WIN1250; SQL> CREATE EXCEPTION  E_ERROR 'err'; SQL> SQL> set term ^; SQL> EXECUTE BLOCK AS CON> BEGIN CON>   EXCEPTI

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-04 Thread Dimitry Sibiryakov
04.09.2020 12:57, Alex Peshkoff via Firebird-devel wrote: Not reproduced: You forgot "set names win1250" at the beginning of the script. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-04 Thread Alex Peshkoff via Firebird-devel
On 2020-08-05 18:48, Ivan Přenosil wrote: In FB2.5 I sometimes construct exception messages with newline like this   EXCEPTION E_ERROR 'msg-á' || x'0A0D' || 'msg-é'; In FB3 and FB4 it can cause error   Statement failed, SQLSTATE = 22000   Malformed string   -At block line: 4, col: 3 Problem is