New Flex2SQL for MS SQL Server v10.x Driver Feature - LOB Support

Picture of Mertech Mertech : Feb 16, 2009 1:19:00 PM

DataFlex News

BLOBs are very large variable binary or character data, typically documents (.txt, .doc) and pictures (.jpeg, .gif, .bmp), which can be stored in a database. In SQL Server, BLOBs can be text, ntext, or image data type.

BLOB data can either be stored inside the database or in the OS file system. A typical example of data stored on the filesystem is product brochure in PDF format or PowerPoint presentations or very large images.

We are adding new commands to allow you to take advantage of reading and writing BLOB types either to the database or to the file system.

New BLOB Commands

LOB_WRITE

LOB_APPEND

LOB_LENGTH

LOB_ERASE

LOB_READ

LOB_TRUNCATE

LOB_LOADFROMFILEExamples of how to use these new commands will be posted.

Data Security with Flex2SQL and BTR2SQL Connectivity Products

Mertech Support: Oct 1, 2025 12:45:52 PM

The most common reason for Enterprises looking to migrate from legacy Btrieve or DataFlex databases is the urgent need to address security and...

Btrieve BTR2SQL Flex2SQL MS SQL Server Oracle MySQL MariaDB

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...

Btrieve BTR2SQL PostgreSQL Modernization ISAM