Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Hi, > Certainly - it's very hard to have remote connections w/o appropriate > provider ;) i supposed that provider is for Firebird Server not for client library. > Yes - seems to be so. > Please add a ticket to the tracker - I will try to find time to > reproduce and fix it. > A. created CORE-5888 > > PS. What does isql do with numerics when started on Android? > How to run isql on Android? regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
On 10.08.2018 10:26, liviuslivius wrote: Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf Providers = Engine12, Remote then another success :) Certainly - it's very hard to have remote connections w/o appropriate provider ;) i have connected from Delphi Firedac on Android to remote firebird without any issues (numerics are ok). Tested with newer Firebird WI-V3.0.4.32954 Firebird 3.0 and then with same version Firebird-3.0.3.32900_0_x64 to remove possibility that something was bad only with older version. It looks like client library work ok only Firebird server on Android have some bug releated to Numerics. Yes - seems to be so. Please add a ticket to the tracker - I will try to find time to reproduce and fix it. A. PS. What does isql do with numerics when started on Android? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf Providers = Engine12, Remote then another success :) i have connected from Delphi Firedac on Android to remote firebird without any issues (numerics are ok). Tested with newer Firebird WI-V3.0.4.32954 Firebird 3.0 and then with same version Firebird-3.0.3.32900_0_x64 to remove possibility that something was bad only with older version. It looks like client library work ok only Firebird server on Android have some bug releated to Numerics. regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Did you try to fetch numerics using isql? i do not know how to run isql on Android Can you attach from your application to remote host? If yes what does happen with numerics in that case? I have tried without success. i have tried by TCP/IP over USB and also by WIFI. I always got "unavaiable database". Should i put copy of firebird.conf in same dir as client lib to support remote connections? I have firebird.conf configured only Providers = Engine12. But client library is in "\Firebird\lib\" and firebird.conf is above in "\Firebird\" regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
On 08.08.2018 14:49, liviuslivius wrote: Hi, i have succesfully connected my Delphi application using Firedac to Firebird embeded on Android. That's great! Firebird version is LI-V3.0.3.32900. I can retrive data from tables from field types: Integer, BIGINT, CHAR, VARCHAR, DATE, TIME, TIMESTAMP, FLOAT, DOUBLE But when i try to fetch something from field of type numeric i got and error: "Fixed length column [F_NUMERIC] data length mismatch. Value length - [2], column fixed length - [8]" i have tested with NUMERIC(18,2), NUMERIC(10,2), NUMERIC(2,1) same problem for DECIMAL(18,2) i simply got an error "Invalid field size". I can't find the reason of this in delphi sources yet - but maybe it is a Firebird on Android problem? If I can fix this problem then I will be able to write complete a tutorial on how to launch Firebird on Android. Did you try to fetch numerics using isql? Can you attach from your application to remote host? If yes what does happen with numerics in that case? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel