Re: How are null's stored?

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