Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA54110 for ; Tue, 30 May 2000 21:44:45 -0400 (EDT) (envelope-from mitch@venux.net) Received: from doot2 (usr3-ip086-grr.wmis.net [209.176.193.136]) by icebox.venux.net (Postfix) with SMTP id DF1F126202; Tue, 30 May 2000 21:49:18 -0400 (EDT) Message-ID: <003501bfcaa2$8d52f4c0$0300000a@doot.org> From: "Mitch Vincent" To: "xu hai" Cc: References: <000801bfca9d$29d27d80$670110ac@xuhaipiii2> Subject: Re: does the' text' type cann't store more than 20,000char ? Date: Tue, 30 May 2000 21:49:51 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200005/213 It can't be any larger than 8k (minus a bit of overhead). You can increase this now to 32k (again, minus the same overhead) by changing BLKSZ to 32k in the config.h header.. I'm successfully doing this in my database (which is pretty high-traffic and pretty large). Good luck! -Mitch ----- Original Message ----- From: xu hai To: Sent: Tuesday, May 30, 2000 9:11 PM Subject: [SQL] does the' text' type cann't store more than 20,000char ? > hi .everyine > when i want put a long file into a field with text type . i was warning the turple is > too long and the table cann't open again.does the' text' type cann't store more than about 9,050 char ? > thank you . > xv hai >