Ryan,
> So if the internal format is identical, why does the INFERNAL database
> ignore indexes when you have a text compared to a varchar?
I don't seem to have this problem; I use TEXT or VARCHAR willy-nilly,
including in LIKE 'string%' and UPPER(field) queries, and the indexes work
fine.
I suspect that either you're talking about TEXT to CHAR(x) comparisons, which
are a different ball o' wax, or your query problem is something else.
--
-Josh Berkus
Aglio Database Solutions
San Francisco