OdbcFirebirdSqlUtil Module

Table of Contents

• OdbcFirebirdSqlUtil Module Introduction
• Schema Management on Firebird
  • Type Mapping
• Release Notes
  • OdbcFirebirdSqlUtil Module v0.1

OdbcFirebirdSqlUtil Module Introduction

The OdbcFirebirdSqlUtil module provides a high level API for working with Firebird database objects through the odbc driver.

Usually this module is loaded on demand from the SqlUtil module, however to use this module directly, use "%requires OdbcFirebirdSqlUtil" in your code.

All the public symbols in the module are defined in the OdbcFirebirdSqlUtil namespace

Note

• This module requires the odbc binary module for communication with Firebird databases plus the Firebird client library and the Firebird ODBC driver
• This module does not yet support schema management for Firebird DBs and only has basic functionality for DML as well; it is experimental; do not use for anything but testing and evaluation

Schema Management on Firebird

Type Mapping

Column types are mapped from Qore types as follows:

OdbcFirebird Column Type Mappings

Qore Type Name	Firebird Type Used
int	bigint
float	double precision
number	varchar
string	varchar
date	timestamp
binary	varbinary
bool	boolean
SqlUtil::BLOB	blob
SqlUtil::CHAR	char
SqlUtil::CLOB	blob sub_type text

Release Notes

OdbcFirebirdSqlUtil Module v0.1

• initial release