ALTER TABLE `<schema>.<table name>` MODIFY CREATE_DT DATE;
Select allOpen in new window
So it is about 65535 characters?
so NUMBER(10,0) = nnnnnnnnnn.0
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
MySQL doesn't have a VarChar2 type, so it needs to convert it. I think some conversion scripts use TEXT if your VARCHAR2 column is more than 255 characters. In older versions of MySQL (<5.0.3), VARCHAR held a maximum of 255 characters, so it would have failed to convert- hence the use of TEXT.
The storage for TEXT and VARCHAR is roughly based on the data that is stored. You can see full details here -> https://dev.mysql.com/doc/
You can read about the DataType here -> https://dev.mysql.com/doc/