Re: Insert into longblob column, it's limitation
¼ÛÅÂÈ£,
Thursday, June 06, 2002, 1:08:07 PM, you wrote:
¼> I will attempt to give you as much information about the software as I can
¼> before I ask the question.
¼> OS : RedHat 7.1
¼> MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
¼> I want to insert into longblob column very big large data.
¼> but.. I have strange Errors...
¼> Example..
mysql>> create table test (aa longblob);
mysql>> insert into test values(load_file('testfile.exe'));
¼> ERROR 1030 : Got error 139 from table handler
mysql>>
./perror 139 ->> Too big row ( >= 16M)
¼> The size of "testfile.exe" is 16.3M
¼> The table type of test is MYISAM
¼> max_allowed_packet = 6700(64M?)
¼> I don't know about this error...
Current limit is 16M, but the data is escaped. It means that the real size
is about 10-12M. It will be changed in future versions ...
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert into longblob column, it's limitation
Good Day
I will attempt to give you as much information about the software as I can
before I ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Errors...
Example..
mysql> create table test (aa longblob);
mysql> insert into test values(load_file('testfile.exe'));
ERROR 1030 : Got error 139 from table handler
mysql>
./perror 139 -> Too big row ( >= 16M)
The size of "testfile.exe" is 16.3M
The table type of test is MYISAM
max_allowed_packet = 6700(64M?)
I don't know about this error...
So..
I want to know the limitation of longblob column for each table Type,
InnoDB, MYISAM.
And. How do insert into longblob column 4G data?
Thank you
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert into longblob column, it's limitation
Good Day
I will attempt to give you as much information about the software as I can before I
ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Errors...
Example..
mysql> create table test (aa longblob);
mysql> insert into test values(load_file('testfile.exe'));
ERROR 1030 : Got error 139 from table handler
mysql>
./perror 139 -> Too big row ( >= 16M)
The size of "testfile.exe" is 16.3M
The table type of test is MYISAM
max_allowed_packet = 6700(64M?)
I don't know about this error...
So..
I want to know the limitation of longblob column for each table Type, InnoDB, MYISAM.
And. How do insert into longblob column 4G data?
Thank you
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
