Create New Data Type

[larry williams]

I understand that MySQL does not support the 'Create Data Type' SQL command that is available in some products, so how do you create a new data type in MySQL? I need to create a special purpose data type based on a BLOB. I've used the BLOB in the MySQL source code as a model and have modified the source to accept my new type. Source builds just fine. But my new data type is not acceptable when trying to create an element of this type. It almost appears as though it needs to be 'registered' some place. My data type, like the BLOB and others, is defined as a symbol, so where can I say, when refering to my type that XXX is MyType? Essentially registering a new data type within MySQL. Anyone else ever done this?

Thanks in advance.