[firebird-support] Info

2017-12-19 Thread Nico Speleers nico.spele...@carfac.com [firebird-support]
Hi, Ex. CREATE TABLE ADDRESSES ( IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL, ADDRESSNAME VARCHAR(100) COLLATE UNICODE_CI_AI, STREETNAMEVARCHAR(100) COLLATE UNICODE_CI_AI, STREETNUMBER VARCHAR(100) COLLATE

[firebird-support] Problem with CONTAINING and COLLATE - UTF8

2017-12-19 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
Hi All, After the original "Problem with CONTAINING and COLLATE" thread I switched to UTF8 but not happy with it. The optional COLLATE after CONTAINING have no effect, the database default COLLATION used. See the below examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu

Re: [firebird-support] Info

2017-12-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.12.2017 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > I want to know the next Id number in my table Addresses without an insert. In > my example > it will be 3. I want to reserve (without an insert) Id number 3 because > someone else can > also ask the next Id

Re: [firebird-support] Problem with CONTAINING and COLLATE - UTF8

2017-12-19 Thread setysvar setys...@gmail.com [firebird-support]
>After the original "Problem with CONTAINING and COLLATE" thread I switched to UTF8 but not happy with it. >The optional COLLATE after CONTAINING have no effect, the database default COLLATION used. See the below >examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu 14.04.1).

Re: [firebird-support] getting generated if before insert (was: Info)

2017-12-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-12-19 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > Hi, > > Ex. > CREATE TABLE ADDRESSES ( > IDINTEGER GENERATED BY DEFAULT AS IDENTITY > NOT NULL, [..] > /* Keys */ > CONSTRAINT PK_ADDRESSES > PRIMARY KEY (ID), > /*

RE: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

2017-12-19 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
Haha, yes that's fair enough. I suppose after this long it's mostly just luck that the IB7.5.1 client library is able to connect to FB3.0.2 at all. Perhaps a better question is whether anyone has experience with this kind of migration where it is difficult to change all clients and servers

[firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

2017-12-19 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
Hi, I've been testing a set of apps that use the InterBase 7.5.1 client library against Firebird 3.0.2 and have found them to be sufficiently compatible (with minimal changes). However after updating a server to Firebird 3.0.3, InterBase 7.5.1 clients (including isql) hang when executing a

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

2017-12-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > Wireshark traces show that the server is sending all the data from the query, > but the > client is not recognising it and waits forever So, you, actually, should ask Embarcadero why their client cannot

Re: [firebird-support] Re: Deadlock error from firebird during midnight

2017-12-19 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Fri, Dec 15, 2017 at 4:25 AM, LtColRDSChauhan wrote: > Ok, i will. > Thank you. > > On 15 Dec 2017 12:34 am, "Helen Borrie hele...@iinet.net.au > [firebird-support]" wrote: > > > > Hello LtColRDSChauhan, > > The net-provider list that you

Re: [firebird-support] Info

2017-12-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello Nico, Wednesday, December 20, 2017, 4:34:09 AM, you wrote: > CREATE TABLE ADDRESSES ( > IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL, > ADDRESSNAME VARCHAR(100) COLLATE UNICODE_CI_AI, > Id = 1 / AddressName = Test / .. > Id = 2 /