зеркало из https://github.com/mono/mail-archives.git
116 строки
3.8 KiB
HTML
116 строки
3.8 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
|
||
<HTML>
|
||
<HEAD>
|
||
<TITLE> [Mono-list] Error Reading from MySQL.
|
||
</TITLE>
|
||
<LINK REL="Index" HREF="index.html" >
|
||
<LINK REL="made" HREF="mailto:joe_audette%40yahoo.com">
|
||
<META NAME="robots" CONTENT="index,nofollow">
|
||
|
||
<LINK REL="Previous" HREF="026064.html">
|
||
<LINK REL="Next" HREF="026067.html">
|
||
</HEAD>
|
||
<BODY BGCOLOR="#ffffff">
|
||
<H1>[Mono-list] Error Reading from MySQL.
|
||
</H1>
|
||
<B>Joe Audette
|
||
</B>
|
||
<A HREF="mailto:joe_audette%40yahoo.com"
|
||
TITLE="[Mono-list] Error Reading from MySQL.">joe_audette@yahoo.com
|
||
</A><BR>
|
||
<I>Sun, 27 Feb 2005 08:30:46 -0800 (PST)</I>
|
||
<P><UL>
|
||
<LI> Previous message: <A HREF="026064.html">[Mono-list] Error Reading from MySQL.
|
||
</A></li>
|
||
<LI> Next message: <A HREF="026067.html">[Mono-list] Error Reading from MySQL.
|
||
</A></li>
|
||
<LI> <B>Messages sorted by:</B>
|
||
<a href="date.html#26065">[ date ]</a>
|
||
<a href="thread.html#26065">[ thread ]</a>
|
||
<a href="subject.html#26065">[ subject ]</a>
|
||
<a href="author.html#26065">[ author ]</a>
|
||
</LI>
|
||
</UL>
|
||
<HR>
|
||
<!--beginarticle-->
|
||
<PRE>Hi Jorge,
|
||
|
||
I have used the TEXT type extensively but not the
|
||
LONGTEXT.
|
||
|
||
The MySQL documentation does have some notes of
|
||
relevance though.
|
||
From:
|
||
<A HREF="http://dev.mysql.com/doc/mysql/en/blob.html">http://dev.mysql.com/doc/mysql/en/blob.html</A>
|
||
|
||
I see
|
||
|
||
The maximum size of a BLOB or TEXT object is
|
||
determined by its type, but the largest value you
|
||
actually can transmit between the client and server is
|
||
determined by the amount of available memory and the
|
||
size of the communications buffers. You can change the
|
||
message buffer size by changing the value of the
|
||
max_allowed_packet variable, but you must do so for
|
||
both the server and your client program. For example,
|
||
both mysql and mysqldump allow you to change the
|
||
client-side max_allowed_packet value. See Section
|
||
7.5.2, “Tuning Server Parameters”, Section 8.3,
|
||
“mysql, the Command-Line Tool”, and Section 8.8, “The
|
||
mysqldump Database Backup Program”.
|
||
|
||
I suspect this is related to the problem you are
|
||
having. The ByteFx provider may not have the packet
|
||
size big enough. You could look at the source for
|
||
ByteFx and see what packet size they are using and
|
||
maybe adjust it there and/or on the server. Might also
|
||
be different using the newer .NET connector for mysql.
|
||
|
||
Hope it helps,
|
||
|
||
Joe Audette
|
||
|
||
--- "Jorge E. Gonzalez" <<A HREF="mailto:jgonzalez@optynex.com">jgonzalez@optynex.com</A>> wrote:
|
||
|
||
><i> I've Web Application, it's working fine but when it
|
||
</I>><i> try to read a field type (LONGTEXT) one erro is
|
||
</I>><i> show.
|
||
</I>><i>
|
||
</I>><i> Error:
|
||
</I>><i> Index and count must refer to a location within the
|
||
</I>><i> buffer. Parameter name: bytes
|
||
</I>><i>
|
||
</I>><i> I'm working whith ByteFX ver 0.76 library
|
||
</I>><i>
|
||
</I>><i> How can I fix this problem o know what's the
|
||
</I>><i> problem?
|
||
</I>><i>
|
||
</I>><i> Thanks
|
||
</I>><i> Jorge Eldis
|
||
</I>><i>
|
||
</I>2‰è–+-™¨¥–+-2‰è–+-–+-³¦‰©Ü¢hm¶Ÿÿ–+-³¦‰©Ü¢oæj)fjåŠËb<C38B>ú?š‰è–+-
|
||
|
||
|
||
=====
|
||
<A HREF="mailto:joe_audette@yahoo.com">joe_audette@yahoo.com</A>
|
||
<A HREF="http://www.joeaudette.com">http://www.joeaudette.com</A>
|
||
<A HREF="http://www.mojoportal.com">http://www.mojoportal.com</A>
|
||
|
||
</PRE>
|
||
<!--endarticle-->
|
||
<HR>
|
||
<P><UL>
|
||
<!--threads-->
|
||
<LI> Previous message: <A HREF="026064.html">[Mono-list] Error Reading from MySQL.
|
||
</A></li>
|
||
<LI> Next message: <A HREF="026067.html">[Mono-list] Error Reading from MySQL.
|
||
</A></li>
|
||
<LI> <B>Messages sorted by:</B>
|
||
<a href="date.html#26065">[ date ]</a>
|
||
<a href="thread.html#26065">[ thread ]</a>
|
||
<a href="subject.html#26065">[ subject ]</a>
|
||
<a href="author.html#26065">[ author ]</a>
|
||
</LI>
|
||
</UL>
|
||
</body></html>
|