I've been experimenting with using the mysql cluster suite with webwork, and I've run into one difficulty. mysql cluster is not able to index columns of type TEXT or BLOB. I've done some fooling around in changing the type of the key fields in the various tables to type VARCHAR(255) instead of TINYBLOB, and things seem to be working properly. I was wondering if there was an underlying reason that these columns were of type TINYBLOB, and if anyone can see any problems that will arise in changing these to VARCHAR(255). The only thing I can think of so far is that this will limit the size of data in these fields to 255 bytes. This would mean that set_ids and user_ids (for example) could not be more than 255 characters, but I don't see this as being a problem.
Any thoughts would be greatly appreciated.