Re: [Firebird-devel] varbinary

2022-01-02 Thread Jiří Činčura
> yes, copy/paste from my source > > > class method > DBvapausfestit_register_forms.insert_or_update_vapausfestit_register_forms( > ID: not nullable System.Guid; EVENT_ID: not nullable System.Guid; > ... Might be a side effect of introducing new datatypes from Firebird 4, with stricter che

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 14:04, Norbert Saint Georges wrote: Thank you for your two responses. unfortunately I have a problem with an old project, following the update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I

Re: [Firebird-devel] varbinary

2021-12-20 Thread Norbert Saint Georges
Jirí Cincura a écrit : update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I have been sending it strings for several months :-) Do you have an example? yes, copy/paste from my source class metho

Re: [Firebird-devel] varbinary

2021-12-20 Thread Jiří Činčura
> update of the netprovider 8.5 client. > Several varchar (x) character set bytes are declared there which > crashes on an expected byte [] even though I have been sending it > strings for several months :-) Do you have an example? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebi

Re: [Firebird-devel] varbinary

2021-12-20 Thread Norbert Saint Georges
Thank you for your two responses. unfortunately I have a problem with an old project, following the update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I have been sending it strings for several months

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 12:40, Norbert Saint Georges wrote: Hello, a varbinary has a subtype of 1 and not 0 (binary) normal? You're thinking of BLOB SUB_TYPE, and this is unrelated to BLOB SUB_TYPE, as it isn't a BLOB type. In Firebird 4, VARBINARY is introduced as *an alias* for VARCHAR CHARACTER

Re: [Firebird-devel] varbinary

2021-12-20 Thread Dimitry Sibiryakov
Norbert Saint Georges wrote 20.12.2021 12:40: a varbinary has a subtype of 1 and not 0 (binary) normal? Yes. According to README.data_types.txt subtype 1 is what distinguishes VARBINARY from VARCHAR. Though at API level subtype is returned as 0 because of limitations of engine internals.