[DB-SIG] Q: API clarification: display_size, internal_size, precision, sca le

Dittmar, Daniel daniel.dittmar@sap.com
Thu, 1 Feb 2001 16:54:35 +0100

Could someone explain more clearly what the diffences are between the
various sizes as required by Cursor.description.

display_size: I guess this is the maximal number of characters a translation
to string would require, so a fixed point number with 3 digits before and
two digits after the decimal point would have a display_size of 6 (3 + 2 + 1
char for the point)

internal_size: probably, a UNICODE (10) would give a display_size of 10 and
an internal_size of 20. What is the intended use? Some databases have a
limitation on the record size or key size, so internal_size could be used to
calculate this.

precision: the number of digits?

scale: the number of digits after the decimal point?

Thanks for any help


Daniel Dittmar
SAP DB, SAP Labs Berlin