Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

RDBMS function to allow NLS developer to retrieve DBCS char from Binary Large Object in their original language or Unicode

IP.com Disclosure Number: IPCOM000011564D
Original Publication Date: 2003-Mar-05
Included in the Prior Art Database: 2003-Mar-05
Document File: 2 page(s) / 45K

Publishing Venue

IBM

Abstract

Disclosed is a method to allow National Language Support (NLS) Relational database application developers to store DBCS characters in Binary Large Object and retrieve them back in their original DBCS characters

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 2

  RDBMS function to allow NLS developer to retrieve DBCS char from Binary Large Object in their original language or Unicode

NLS Relational database application developers who want to store DBCS characters in Binary Large Object and retrieve them back in their original DBCS characters cannot do so because DB2 select only returns Hexadecimal chars.

The common work around used is to store the DBCS chars in a VARCHAR field in UTF-8 (unicode) enabled database. But this design has major limitations : 1) Not all existing databases are UTF-8 enabled and migration from a non-unicode to UTF-8 enabled database is a big effort 2) VARCHAR has its limitation in length whereas BLOB does not 3) When the DBCS data stored in BLOB is retrieved from database, an external code conversion is required. This has proven to be problematic for many developers and causes much code duplication in development across applications.

Disclosed is a method to allow National Language Support (NLS) Relational database application developers to store DBCS characters in Binary Large Object and retrieve them back in their original DBCS characters

A database (DB2) function is implemented to give NLS database application developers more flexibility for their choice of application design. That is with this function, user can perform a select statement against a Binary Large Object that stores DBCS char data and the return results will be in their original language or unicode such as UTF-8.

This function can be used either from DB2 command line or in the SQL query statements within an application program.

High Level architectural implementation is as follows:

The database function can be designed to take in three parameters: the first parameter can be...