Importing Progress table definitions

IFMTCS · Post by **IFMTCS** » Fri Aug 18, 2006 3:14 am

When we import Progress Database table definitions into DS through ODBC the length of some fields is changing. Length of intger fields is getting doubled...can any one explain why it is happening so....

ray.wurlod · Post by **ray.wurlod** » Fri Aug 18, 2006 10:04 am

They are being recognized as NChar or NVarChar, and two bytes per character are being reserved.

IFMTCS · Post by **IFMTCS** » Fri Aug 25, 2006 3:19 am

Thanks Ray. As u said it is recognised as Varchar. All the Char fields are also getting doubled. Can u tell me how to get the exact table definition.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 10:26 pm

You are getting whatever the ODBC driver reports during import. The only way to change that is to edit it afterwards (or perhaps to get a different ODBC driver).