Hello Dmitry, we have solved the problem. Windev has apparently modified the way some data types work in the latest version. I will attach the solution in case you need to give it to any other Windev developers. I appreciate all your time and assistance and apologize for wasting your time when it was a […]
FB4. FINISH
I am verifying the new release of our ADO.NET provider for OLE DB and thinking that this picture will be useful for anyone, who is planning to start using the combination of FB4, .NET and IBProvider 🙂
The load tests of IBP v5.31.1 with FB4 has finished today. No real problems were detected. A few little issues with first dialect have been already fixed in version 5.31.5. During these tests Firebird ate the 116 days of my CPU time 🙂 It’s time to start testing IBP v5.31.5 and begin implementing the support […]
New IBProvider 5.31.1.43971 has added the support of UTF16 symbols for alternative text literals. It means that provider will be correctly processing the following query: select _win1251 q’?мама, мама, что я буду делать??’ from rdb$database; I hope that Firebird will be able to process this query in the near future. Note that, you should use […]
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.
