Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 19:11:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The message refers to an InfoType of 0.

Assuming the InfoType is the ODBC data type, that indicates that the ODBC driver is unable to identify the column type. The type should be 1 for a character column. Zero means 'Unavailable or Unknown'.

When you say 'text' do you specifically mean the MSAccess 'Text' type (a 1 to 255 character string) or might you be refering to a 'Memo' (in Access) field. The 'Memo' is actually a CLOB (Type is -1) and is used to store any string larger than 255 bytes.

It is quite likely that Access will have a problem loading CLOB data - especially if it tries to load it to a CHAR(2200000000) field rather than a CLOB or a CHAR(64000). [CLOBs are handled differently by different vendors, and have different limits - as do CHAR fields - so I dont know how well Access handles them.]

(If you are working with Unicode strings the data types would be -8 and -10 rather than 1 and -1. Access itself stores all strings in Unicode in the 2000 version.)

Not sure if this really helps you but I thought some background might help.

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>