On Thu, Jun 02, 2005 at 10:21:13AM +1000, Angus Johnson wrote: > name - use varchar as text fields cannot be indexed at least not in MySQL
Or use PostgreSQL instead of MySQL and use text fields. Any size you like and indexable as well. > As far blob vs text they're pretty much synonyms for same type. Only > difference is that blob is case sensitive on sorts and criteria where > text is insensitive. Paul "Postgres evangelist" Haddon Sydney, Aus --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
