Different decimal point character for numeric limit test vs multiple numeric test with database logging

[gnyx]

Hi all,
I have a problem with decimal point character and database logging.
I've deselected "Use Localized Decimal Point" in Station Options->Localization. Teststand should now use "." as decimal point character (ignore the "'s).
When logging to database this is only true for Multiple numeric limit test results, not for Numeric limit test results.

Numeric limit test results use "," as decimal point character where it should be "."

I can't trust the localization settings on the PC as different endusers might have different settings.

Example:
(STEP_NAME and PROP_RESULT.DATA)
Numeric limit test 1,50127667932332
Multiple numeric limit test result_1 1
Multiple numeric limit test result_2 1
Multiple numeric limit test result_3 10.0304317

I've changed the Limits->Numeric format for each test but this change is only applied to the report, not the database result.
Read the manuals but didn't find anything...

Have I missed something obvious, or is this some kind of bug?

Teststand version is 2010.

Windows versions are XP SP3 and Win7. Same behavior on both OS.

[gnyx]

Problem solved. Note to self:

Goto Database Options->Statements.

Select STEP_NUMERICLIMIT1

Open Columns/Parameters

Select Data in "Columns in.."

Change Type to String(VarChar), size 255.

Default for PROP_MULTINUMERICLIMIT1.DATA is String, hence the behaviour.

[dug9000]

When something is logged to the database as a number, the database is probably storing it in a way that is independent of any sort of decimal point localization. When you view the items in the database however it is probably going to show you the number based on the current locale settings. This is likely purely cosmetic, for display purposes.

-Doug

[gnyx]

PROP_RESULT.DATA is a varchar(255), so the number is converted to a string when saved to the database. It is not stored as a number in the database as PROP_RESULT.DATA handles results from both numeric and string tests etc

[dug9000]

What schema and version of TestStand are you using? On my machine the type for that property is set to "Double Precision".

-Doug

[gnyx]

Teststand 2010 with a modified generic schema. 

The modifications contains information about test equipment etc, default tables used for data.