Hi,
There is a column in my csv text file that has only 1 character,
the metadata is audo detected as longvarchar, is it configurable
so that I can let the auto dected meta to be varchar.
Thanks!
|
You can use CREATE TABLE to assign it as varchar(1). Because HXTT Text (CSV) need to consider insert/update operation so that it won't detect and reduce the max length for varchar type.
|