What data types are supported by MySQL Cluster?
MySQL Cluster supports all of the usual MySQL data types, with the exception of those associated with MySQL’s spatial extensions. (See Chapter 17, Spatial Extensions.) In addition, there are some differences with regard to indexes when used with NDB tables. Note: MySQL Cluster Disk Data tables (that is, tables created with TABLESPACE … STORAGE DISK ENGINE=NDBCLUSTER) have only fixed-width rows. This means that (for example) each Disk Data table record containing a VARCHAR(255) column requires space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters stored therein. See Section 15.14, “Known Limitations of MySQL Cluster”, for more information about these issues.
MySQL Cluster supports all of the usual MySQL data types, with the exception of those associated with MySQL’s spatial extensions. (See Chapter16, Spatial Extensions.) In addition, there are some differences with regard to indexes when used with NDB tables. Note: MySQL Cluster tables (that is, tables created with ENGINE=NDBCLUSTER) have only fixed-width rows. This means that (for example) each record containing a VARCHAR(255) column will require space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters stored therein. This issue is expected to be fixed in a future MySQL release series. See Section15.11, Known Limitations of MySQL Cluster, for more information about these issues.
MySQL Cluster supports all of the usual MySQL data types, with the exception of those associated with MySQL’s spatial extensions. (See Chapter 18, Spatial Extensions.) In addition, there are some differences with regard to indexes when used with NDB tables. Note: MySQL Cluster tables (that is, tables created with ENGINE=NDBCLUSTER) have only fixed-width rows. This means that (for example) each record containing a VARCHAR(255) column will require space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters stored therein. This issue is expected to be fixed in a future MySQL release series. See Section 16.9, “Known Limitations of MySQL Cluster”, for more information about these issues.
MySQL Cluster supports all of the usual MySQL data types, with the exception of those associated with MySQL’s spatial extensions. (See Chapter 16, Spatial Extensions.) In addition, there are some differences with regard to indexes when used with NDB tables. Note: MySQL Cluster tables (that is, tables created with ENGINE=NDBCLUSTER) have only fixed-width rows. This means that (for example) each record containing a VARCHAR(255) column will require space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters stored therein. This issue is expected to be fixed in a future MySQL release series. See Section 15.8, “Known Limitations of MySQL Cluster”, for more information about these issues.
