Page 1 of 1
Importing Progress table definitions
Posted: Fri Aug 18, 2006 3:14 am
by IFMTCS
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....
Posted: Fri Aug 18, 2006 10:04 am
by ray.wurlod
They are being recognized as NChar or NVarChar, and two bytes per character are being reserved.
Posted: Fri Aug 25, 2006 3:19 am
by IFMTCS
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.
Posted: Fri Aug 25, 2006 10:26 pm
by ray.wurlod
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).