MSSQL column numeric scale ignored in query results

dev
1

I’m guessing this is more of a MSSQL driver issue than an Lucee issue but just thought I’d do a post to see what others have found.

In one of our tables we have a numeric(5,2) column with values such as:

3.01, 3.10, 2.60

In the query results that column is returning:

3.01, 3.1, 2.6

This issue is not occurring on any of ColdFusion versions.

I have tried switching drivers but get the same results no matter which I try.

Thanks
Paul

2

Please always describe your software stack! :sunglasses:

I.e what versions etc

Have you tried the 6.2.1 RC

3

Sorry, yes I should know better.

I have not tried 6.2.1 RC I am doing my testing with Lucee Express 6.2.0.321.

I will get a copy of 6.2.1 RC and try that and get back to you.

4

ah, least your are on the latest stable.

I seem to remember an issue about this, but not so recently, let me check

5

Here are some screen shots, if these help.

Screenshot 2025-04-16 142332
Screenshot 2025-04-16 1423321382×446 53.5 KB

image-2025-4-16_11-12-4
image-2025-4-16_11-12-41457×536 96.3 KB

6

what does dump(getMetaData(q)) show?

7

image

NOTE: I did upgrade to the latest RC with no differences.