Text only | Text with Images

Simple Machines Community Forum

General Community => Scripting Help => Topic started by: Curbow 5 on January 05, 2004, 07:20:12 AM

Title: MySQL field type question
Post by: Curbow 5 on January 05, 2004, 07:20:12 AM
What field type (varchar, text, etc) would one assign to a field containing a 'large' amount of text? (100k+) Thanks!
Title: Re: MySQL field type question
Post by: pulpitfire on January 05, 2004, 10:01:41 AM
text?  (that's a pretty tricky avatar.)
Title: Re: MySQL field type question
Post by: Curbow 5 on January 05, 2004, 10:15:36 AM
thanx, lol! :D
doesn't text have a limit to number of chars it can take in? cause that's what i'd like!
Title: Re: MySQL field type question
Post by: pulpitfire on January 05, 2004, 10:31:48 AM
well, check here:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_TABLE
http://www.mysql.com/documentation/mysql/bychapter/index.html#BLOB

you might need something like MEDIUMTEXT or LONGTEXT
Title: Re: MySQL field type question
Post by: Curbow 5 on January 05, 2004, 10:45:59 AM
thanx again! i found my answer! i think i'll go with longblob....
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB

edit: or just mediumblob, since that's still about 2mb.....  :o
Text only | Text with Images