Normalization is good, but it does not eliminate the usefulness of data typing whether that typing is weak aliasing or more real. Both are worth pursuit.

I don't know what MySQL provides as support for user defined types. I don't believe that any such support will be standard SQL.