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 [EMAIL PROTECTED] | | Bioinformatics programming/database/sysadmin (530)754-9127 | +---------------- said t e lawrence, picking up his fork ----------------+
