MySQL Forums
Forum List  »  Memory Storage Engine

unable to create BLOB/TEXT columns for HEAP table
Posted by: Jack Ling
Date: April 19, 2005 08:25PM

Hi,


I'm trying to create a heap table. But there is an error saying that I can't use BLOB/TEXT columns for HEAP. Understand, but my table does NOT have BLOB type fields, only have common fields like char, varchar (*I've even change the varchar into char afterwards). Here is my table structure. Please give me guidelines. Thanks, Jack Ling:


CREATE TABLE TABLE_HEAP
(
LIC_NO char(6) NOT NULL,
ADDRESS char(40) NULL,
TEL char(8) NULL,
FAX char(8) NULL,
CO_CONTACT char(50) NULL,
CO_NAME char(50) NULL,
M_STREET char(50) NULL,
M_STREET1 char(50) NULL,
M_BLDG char(50) NULL,
M_BLDG1 char(50) NULL,
M_AREA char(30) NULL,
M_DIST char(3) NULL,
IN_STREET char(50) NULL,
IN_STREET1 char(50) NULL,
IN_BLDG char(50) NULL,
IN_BLDG1 char(50) NULL,
IN_AREA char(30) NULL,
IN_DIST char(3) NULL,
AREA_CODE char(3) NULL,
CODE char(3) NULL,
FILE_REF char(12) NULL,
RMS_REF char(12) NULL,
WORK_TYPE char(3) NULL,
LIC_DATE date NULL,
WIPE_TEST char(1) NULL,
SOURCE_TYPE char(1) NULL,
MED_EXAM char(1) NULL,
INSTRUMENT_REMARK char(100) NULL,
LICENCE1 char(60) NULL,
LICENCE2 char(75) NULL,
LICENCE3 char(75) NULL,
PURPOSE1 char(60) NULL,
PURPOSE2 char(75) NULL,
PURPOSE3 char(78) NULL,
NOTE1 char(75) NULL,
NOTE2 char(75) NULL,
NOTE3 char(75) NULL,
EQUIP_DESC char(762) NULL,
COMP_SV char(50) NULL,
PRINT_MADD1 char(75) NULL,
PRINT_MADD2 char(75) NULL,
PRINT_SADD1 char(75) NULL,
PRINT_SADD2 char(75) NULL,
DISP_NO char(6) NULL,
AMEND_ID char(6) NULL,
AMEND_DATE date NULL,
EMAIL char(50) NULL,
STATUS char(1) NULL,
CREATE_DATE date NULL,
CLOSE_DATE date NULL,
LIC_PERIOD smallint NULL,
organization char(8) NULL,
renewed_date date NULL,
modify_renewed_date date NULL,
licence_sys_date date NULL,
close_sys_date date NULL,
comp_name_chn char(60) NULL,
default_language_content char(1) NULL,
default_language_company char(1) NULL,
inactive_date date NULL,
create_sys_date date NULL,
PRIMARY KEY (LIC_NO)
) TYPE=HEAP;

Options: ReplyQuote


Subject
Views
Written By
Posted
unable to create BLOB/TEXT columns for HEAP table
7605
April 19, 2005 08:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.