hey all still a bit of newbie but im having problems saving more than around 65000 or so charactors to my DB field is set as "text". What other things can i use to store say 100,000 chars. like long text, blob etc or cant this be done
Robber
8:26 am on Jul 4, 2003 (gmt 0)
You could try a LONGTEXT or LONGBLOB - should give you a few more characters to play with.
blind
8:49 am on Jul 4, 2003 (gmt 0)
does anyone know for sure?
Paul in South Africa
10:19 am on Jul 4, 2003 (gmt 0)
LONGBLOB LONGTEXT A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters.
from ht*p://www.mysql.com/doc/en/Column_types.html
ShawnR
10:55 am on Jul 4, 2003 (gmt 0)
What are you trying to do... It might make sense to generate a unique text string to use as a filename, and store the text in a file, with the DB field storing the file path. Just depends on whether you expect to have to search on the contents of the large amount of text (even if you do, a separate process which generates an index of the words in the large text might be a better solution. So what are you trying to do?
Shawn
blind
11:02 am on Jul 4, 2003 (gmt 0)
yeah long text works great thanks yeah i need to search the text as well and dont wanna get in too deep, so it all works good now
