Cast Functions and Operators 2238 Produces a result of type  REAL . This is actually  FLOAT  if the  REAL_AS_FLOAT  SQL mode is enabled; otherwise the result is of type  DOUBLE . Produces a signed integer value. As of MySQL 8.0.24,  CAST()  and  CONVERT()  support casting geometry values from one spatial type to another, for certain combinations of spatial types. The following list shows the permitted type • spatial_type • SIGNED [INTEGER]