Hi, Lars,
Thanks. I have cracked down this problem.
It is very easy in C/C++, as follows:
int main(...)
{
max_allowed_packet = 1024 * 1024 * 32; /* 32M communication buffer needed */
.....
}
Lin Kui
-----邮件原件-----
发件人: lars [mailto:lars] 代表 Lars Heidieker
发送时间: 2002年9月24日 22:47
收件人: Lin Kui
主题: Re: help for mysql_fetch_row error on a large field
Hi,
have a look for the variables max_allowed_packet which is 1Mb by default. It limits
the the size of the records that can be transfered. max_allowed_packet ist a server
configuration option and there is some client (16Mb default) option as well. Have a
look in the Manual and search for limits or packet
Lars
Lin Kui wrote:
> Hi, all,
>
> when I use mysql_fetch_row(myRes) and there is a very large field
> (~30M long), my program crashed. How can I solve the problem?
> For less than 5M long string/text, it works well. thanks.
> My machine is Linux 7.3 & MySQL is 4.0.3-beta.
>
> Best regards.
> ~~~~~~
> Lin Kui
> College of Life Sciences
> Beijing Normal University
> Beijing 100875
> P. R. China
>
> ---------------------------------------------------------------------
> 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
--
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, daß sie noch nicht einmal oberflächlich sind.
--Friedrich Nietzsche
---------------------------------------------------------------------
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
