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! | ||
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. |