Patent Yard Sign in
Expired Canadian patentCanada

Support of mixed single and double byte data in a relational databaseproduct

CA 1290455 C · Owner: International Business Machines Corporation · Inventors: Chang, Philip Y.; Engles, Robert W.; Trumble, Mary K.

CIPO record

Overview

Drawings and full text

Its claims, description and drawings are in the Canadian Patents Database.

Open the CIPO record

Abstract From the Canadian patent

In the relational database system of the present invention, an extension to the SQL language is provided to allow a user/application to specify whether a column in a database table contains only single byte character set data, or mixed single byte character set data and double byte character set data. Specifying whether a column contains single byte character set data or mixed data is achieved by specifying the subtype of the character data types including CHAR VARCHAR, and LONG VARCHAR. The user application can specify the subtype of character data within a column as the column is created or added by specifying FOR SBCS or FOR MIXED in either the CREATE TABLE statement or the ALTER TABLE …

Read the whole patent

Listed from its CIPO record in Patent Yard's archive of Canadian patents past their term. Its claims, description and drawings are in the CIPO record and on Google Patents, and the Claude kit works from them.

Why it's free to use

  • Granted October 8, 1991. A Canadian patent filed before October 1, 1989 lasted 17 years from grant, so its term ended October 8, 2008.
  • We check Canadian rights only. A patent in its family in another country could still be in force: check its family on Google Patents.
FiledJanuary 27, 1989
GrantedOctober 8, 1991
Term endedOctober 8, 2008
Patent numberCA 1290455 C
Classification (IPC)—

Timeline

Timeline From CIPO dates

1990199219941996199820002002200420062008Application filedJan 27, 1989Patent grantedOct 8, 1991Term endedOct 8, 2008

Sources & verification

Everything on this page comes from the CIPO record linked above. Contains information licensed under the Open Government Licence – Canada.