MySQL Forums
Forum List  »  MyISAM

Can't insert BLOB field (MySQL 3.23)
Posted by: Alex
Date: April 06, 2006 02:49AM

Hello !
I'm working with MySQL 3.23.34a, Windows 2000 and try to execute the following:

create table if not exists t1 (g longtext,h longtext)
INSERT t1(g,h) values (null, null)
UPDATE t1 SET g=LOAD_FILE('c:/f1.bin')
UPDATE t1 SET h=LOAD_FILE('c:/f2.bin')

After the 2-nd UPDATE I have got an error :
"Got error 139 from table handler"

Size(f1.bin)= Size(f2.bin)= 12Mb. If Size(f1.bin)+ Size(f2.bin) <= 16Mb script is executed successfully. The variable max_allowed_packet= 64 Mb. Is there the way to manage this problem ?

Alex

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't insert BLOB field (MySQL 3.23)
5248
April 06, 2006 02:49AM


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.