Frank Stanovcak wrote:
So what I'm taking away from this is that I can index a text column, but
that is relatively new. Based on experience with technology I'm going to
guess it's not a very efficient index or search function yet. CHAR seems to
be well entrenched, and the favorite for any column I may need to search
against. I just need to be warry of the size limits and account for them in
my program and data entry.
Does that seem to be the consensus?
certainly not from this end; all the column types have been around since
forever and it's mroe about picking the appropriate type for the job.
If it's short variable length strings then use varchar.
If it's short fixed or max length strings that will most frequently sit
with a length near max length then use char.
If it's a decent amount of text over 250 chars then use a text column.
For all three you can index them using normal indexes; or if you need to
use the fulltext search features then you can add a fulltext index to
the column(s) in need. (only with myisam tables).
You'll find the types are named v well, so if it's to hold fixed length
char data use char, variable legnth char data then use varchar, bit of
text use text, long bit of text use longtext and so on.
:)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
