Can we extend the max length of the data types varchar and varbinary to 65535?
We plan to migrate the history data from MySQL to MariaDB ColumnStore. However, we encountered some problems related to the data types, such as: 1. The max length of varchar and varbinary is 8000. 2. It cannot support Text/Blob data types. Will it support more data types and be compatible with the row store of MariaDB? Please reply in your convenient time. Thank you very much.
Answer Answered by David Thompson in this comment.
The column limit is a function of the mariadb server (and also mysql) so is a more complex problem to solve in terms of impact. The mixed storage engine is an interesting use case - i have filed improvement https://jira.mariadb.org/browse/MCOL-362 to track this. At this point in time the mariadb team is focused on completing the port and moving towards a stable GA version. I think your only option for now is to consider a different storage architecture for your texts or blobs.
