The new build (5.31.0.43938) of IBProvider adds the new feature — getting the NUMERIC/DECIMAL values as text. It will help resolve the problems with reading these datatypes through linked server. For example, Firebird (and InterBase) allows to save value 1 into column with datatype NUMERIC(4,4). Yes, it is really possible: When you try to read […]
The following example demonstrates the support of DBTIMESTAMPOFFSET datatype for non-FB4 servers. This simple code connects to FB3 and asks IBProvider to translate ‘2023-08-09 21:53 Europe/Moscow’ string into binary presentation of TIMESTAMP WITH TIME ZONE datatype — DBTIMESTAMPOFFSET. Provider will do it with help ICU library.
Hello All. I think, the development of FB4 TIMESTAMP WITH TIME ZONE support has been arrived a final stage. Provider can process time zone regions itself and through ICU (v63.1). By default, this datatype will be mapped on the text (WSTR) but you can map it on MSSQL datatype DBTIMESTAMPOFFSET, too. For configuring a behavior […]
Hello one more time. As I have said early, MSSQL processes TIMESTAMP WITH TIME ZONE datatype using DBTIMESTAMPOFFSET structure OLE DB. Today I have checked it again. It is so really. By default IBProvider publishes TIMESTAMP WITH TIME ZONE as text but you can change this behavior using dbtimestamp_with_tz_rules property. That I did in this […]
The load test of IBProvider v5.30 with FB4 lasted more than two weeks and ended today. No problems were detected. Firebird v4.0.3.2950 state. Ok. Let’s start the next tests.
Hello All. The new example was added at IBProvider website — «Resetting the session settings before reusing a connection (C#, FB4)». This examples demonstrates an implicit usage of the new magic FB4 feature — «ALTER SESSION RESET». It allows to implement the true connection pool at last. Both installers (IBProvider Trial and ADO.NET provider) were […]
Hello All. The new trial [5.30.0.42557] provides the support for the new FB4 datatypes — DECFLOAT16 and DECFLOAT34. There is supported simple columns and columns with arrays. Currently, IBProvider maps these types to string datatype (WSTR). I think, in the future the provider will provide other, native ways for work with these datatypes.
Hello Everyone. I have just gotten the some of results about load test IBP with FB4 those can be analyzed and compared. In short, the situation is the same as for FB3. Test with using built-in Firebird client Test with using fbclient.dll The errors in first case (built-in client) are linked with new unsupported FB4 […]
Hello All, The new build of IBProvider Trial [42372] provides the completed support of INT128 and NUMERIC that is based on INT128. You can use these types for simple values and, of course, for values with arrays. There were created and passed lots of different tests, so I hope am sure that all is OK. […]
Hello Everyone. The new IBProvider Trial [build 42030] includes the initial support for Firebird v4. The primary limitation: this version is not able to read and write values with new datatypes (INT128, DECFLOATxx, TIME/TIMESTAMP WITH TIME ZONE) but you can read the metadata of these things. You can connect to FB4 through fbclient.dll and directly […]
