Welcome Guest, Not a member yet? Register   Sign In
TEXT vs Varchar : need your advice.
#1

[eluser]FutureKing[/eluser]
I am creating a CMS which will handle articles/images/videos and more...
There are two important fields in it "Cont_text" and "Cont_type".
Cont_type will determine how to handle the content of Cont_text.
If Cont_type is image then Cont_text will be handled as filename of image
If Cont_type is article then Cont_text will be handled as html text.

The confusion/problem is, The type of Cont_text is "TEXT". Should I use "TEXT" to handle small files names as well as big articles. Or should I create separate column for storing small data like filename.

Full detail is given in the following file. Please check:
http://www.easy-share.com/1907348329/cms.doc

Please reply ASAP so that I can start building my website.


Messages In This Thread
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 04:07 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 05:33 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 05:40 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 07:55 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 08:00 AM
TEXT vs Varchar : need your advice. - by El Forum - 08-15-2009, 10:30 AM



Theme © iAndrew 2016 - Forum software by © MyBB