The Vertica Database Forums

Hi,

I have a task to transfer data from mySql database to Vertica. But there is a column with 'TEXT' datatype in mysql which exceeds 64000bytes. Could anyone suggest how to handle such datatypes in vertica.

Thanks in advance.

You can use LONG VARCHAR if you're on version 7. However, you should evaluate the need for and avoid such data due to performance issues (and poor encoding).