Updated: 2023-08-16

Data Source Initialization OLE DB Property — «timezones_source»

Name:
timezones_source
Type:
VT_BSTR
R/W:
R/W
Default:
EMPTY
IBProvider:
5.31

This property defines the type of time zone information source. You can define one from the following values:

Value Description
icu Provider uses ICU for processing time zone regions.
server Provider loads time zone information from database server.

When ICU is specified to handle time zone regions, provider uses the dynamic library defined in icuin_library (icuin_library_64) property.

If this property has «server» value, provider will query server all the necessary information and will been processing time zone regions itself.

The «server» mode requires the help from the server side. For example, in case FB4, provider will call the system stored procedure RDB$TIME_ZONE_UTIL.TRANSITIONS.

When the value of this property is not defined, provider chooses it itself on base of server version:

Server Default value
InterBase icu
Firebird v1-v3 icu
Firebird v4 server

See also

Other properties of group

Other sets of properties