3 messages in com.mysql.lists.mysqlRe: Heap Help
FromSent OnAttachments
gunm...@gunmuse.com29 Nov 2004 12:09 
Steve Edberg29 Nov 2004 14:08 
Dathan Vance Pattishall29 Nov 2004 14:09 
Subject:Re: Heap Help
From:Steve Edberg (sbed@ucdavis.edu)
Date:11/29/2004 02:08:45 PM
List:com.mysql.lists.mysql

At 1:09 PM -0700 11/29/04, <gunm@gunmuse.com> wrote:

I want to put a table in Ram (HEAP) with a field of at least 500 characters. I do I do this if Blob and text are not allowed?

The glib answer would be: you can't.

Two alternatives would be: (1) split your text field up into as many char/varchar columns as necessary 9eg; text_part_1, text_part_2, ...), and then split/rejoin those columns programmatically; or, (2) you might be able to losslessly compress or otherwise encode your text such that it will fit into a char(255) or smaller column.

Thanks Donny Lairson President <http://www.gunmuse.com/>http://www.gunmuse.com 469 228 2183

-- +--------------- my people are the people of the dessert, ---------------+ | Steve Edberg http://pgfsun.ucdavis.edu/ | | UC Davis Genome Center sbed@ucdavis.edu | | Bioinformatics programming/database/sysadmin (530)754-9127 | +---------------- said t e lawrence, picking up his fork ----------------+