#10 MS-Access: Improper Column Size Returned

[Anonymous]

In MS-Access, when the following command is ran:

foreach item [db columns $tableName] {
# Break apart each column to its base elements
# set TABLE_QUALIFIER [lindex $item 0]
# set TABLE_OWNER [lindex $item 1]
# set TABLE_NAME [lindex $item 2]
set COLUMN_NAME [lindex $item 3]
# set DATA_TYPE [lindex $item 4]
set TYPE_NAME [lindex $item 5]
# set PRECISION [lindex $item 6]
set LENGTH [lindex $item 7]
# set SCALE [lindex $item 8]
# set RADIX [lindex $item 9]
# set NULLABLE [lindex $item 10]
# set REMARKS [lindex $item 11]
# Create an array representing table's Columns
set arr($COLUMN_NAME.type_name) $TYPE_NAME
set arr($COLUMN_NAME.length) $LENGTH
} ; # end foreach

The LENGTH Variable is returning values that are
exactly 2 Times (2x) greater than the set Column Width
in the database.

I talked to Roy about this - he suggested a submission
to SourceForge as a BUG.

Any questions, Contact me:

davidhbigelow@compuserve.com