Browse Prior Art Database

Expanded Codepage Identification Information

IP.com Disclosure Number: IPCOM000034590D
Original Publication Date: 1989-Mar-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 1 page(s) / 12K

Publishing Venue

IBM

Related People

Alexander, VL: AUTHOR [+3]

Abstract

Disclosed are some expansions to an exchange file format for relational database tables in order to identify 'bit data' stored in character fields, as well as to identify the codepage of all character (and graphic) data. These expansions make the format usable for migration of data between a mainframe computer and a personal computer, and among different personal computers (or the same personal computer) operating in the same or different codepage environments. Add single-byte and double-byte codepage fields to the previously architected 'header' record which provides general information about the contents of the database exchange file. The 'header' record single- and double-byte codepage fields specify the codepages of all character data in the exchange file except for the actual column data values.

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

Page 1 of 1

Expanded Codepage Identification Information

Disclosed are some expansions to an exchange file format for relational database tables in order to identify 'bit data' stored in character fields, as well as to identify the codepage of all character (and graphic) data. These expansions make the format usable for migration of data between a mainframe computer and a personal computer, and among different personal computers (or the same personal computer) operating in the same or different codepage environments. Add single-byte and double-byte codepage fields to the previously architected 'header' record which provides general information about the contents of the database exchange file. The 'header' record single- and double-byte codepage fields specify the codepages of all character data in the exchange file except for the actual column data values. (Data within 'extra' records which are application specific could also be exceptions to this rule.) Expand the previously architected 'column descriptor' records to include single-byte and double-byte codepage fields for each column of data within the exchange file. For character (and graphic) columns, the single- and double-byte codepage fields in the 'column descriptor' record for the column specify the codepage(s) of the data for the column. A character column of 'bit data' is identified by a zero single-byte codepage value. These codepage identification fields allow programs responsible for migration of database data b...