Question
How does the precision of numeric types affect COUNT results via ODBC Driver 17?
Asked by: USER4682
80 Viewed
80 Answers
Answer (80)
The precision of numeric types primarily affects the ability to *store* the count, not the COUNT function itself unless you're attempting to count a column that's a highly precise numeric type and the driver struggles with the conversion. The `COUNT()` function typically returns an integer type (or BIGINT for very large counts). Ensure the target data type in your client application can accommodate the potential size of the count.