Field news
Hello Everyone. The release x64 binary of the next IBProvider v5.32 was tested. All is OK 🙂
Archive by Author
Field news
Hello Everyone! The first test iteration of the release candidate has been completed. It was the most scary part of this test process. The result of next parts can be predicted.
Field news
FB4. FINISH
FB4 and Visual Studio
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 🙂
Field news
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 […]
Alternative Text Literals
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 […]
Release of ADO.NET Provider v1.27
Hello All. It is a small update of our LCPI ADO.NET provider. We have added the support of latest new IBProvider properties: decfloat16_rules decfloat34_rules int128_rules dbtimestamp_with_tz_rules dbtime_with_tz_rules timezones_source icuin_library icuin_library_64 sql_cache__scope sql_cache__instance_id sql_cache__size sql_cache__time sql_cache__max_len All the changes were made in OleDbConnectionStringBuilder. You can see these changes in the connection configuration of DDEX provider. Data […]
Getting NUMERIC and DECIMAL as text
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 support of DBTIMESTAMPOFFSET
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.
[FB4] TIMESTAMP WITH TIME ZONE
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 […]