HXTT Text(CSV)
longvarchar
Lucy
2007-06-20 14:44:52.0
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!
Re:longvarchar
HXTT Support
2007-06-20 19:06:02.0
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.


Google