HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, XML JDBC, Data Export Import for Sybase, DB2, Oracle

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.

Address:	9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode:	411100
Phone:	(86)731-58225727
Fax:	(86)731-58225727
Email:	webmaster@hxtt.com