QUOTE(itdemo @ 15 Jul, 2008 - 09:11 AM)
QUOTE(BetaWar @ 13 Jul, 2008 - 07:09 PM)
Most forums take the safe approachj and say varchar 60,000 to make sure there is enough space without overflow.
Thanks for the reply but what do you mean by "varchar 60,000". Sorry but i am still only learning php so could you please explain it more.
Thanks,
ITDemo
varchar is a datatype in a mysql database. There are varchar's, int's, text's, date's, bool's, etc. They all correspond to a different type of data. It's important to know which is which to ensure your database is efficient.
Also, for varchar's, I believe one character is one byte, so 60,000 would by 60,000 bytes, or 60K. You want to keep this in mind when you're building your database. You wouldn't want to use varchar 100 for something that's going to be only 5 characters long, because it's a waste of memory.
Before you start jumping into your forum you really need to understand what you're doing. Read tutorials on database management and PHP and ensure that you fully understand the concepts you're working with before tackling such a large project. It will save you a lot of time and frustration down the road.
13 Jul, 2008 - 04:37 PM
|