comma (,) not working as a decimal separator

[rad2]

The issue is I have a record producer(RP) on a custom table. In this RP is a STRING field to store COST. 

I enter 12,3 in the COST field.

I expect it to be stored as 12,3 . When i query the newly created record on my custom table i see 123.

',' comma in my locale is a decimal separator.

1. There are no client scripts running on the table

2. the decimal separator when checked in background script is ',' comma

3. the issue is seen on record producer

4. browser location is also set according

[Tony Chatfield1]

Hi, unfortunately your post does not contain clear details of your issue or configuration.
If you entered '12,3' into a 'string' field then I would expect the result to be '12,3'

Can you clarify the data type of the field involved?
Do you have any client scripts configured that might be altering the data inputted to the form?

[rad2]

Hello Tony,

Thanks for the reply. When i enter 12,3 on record producer --> it saves it as 123 in the backend record form. i would want it to be saved as 12.3(decimal)

[Tony Chatfield1]

Hi, what is the data type of the record producer field?
Have you looked at localization and issues that may result from use of regional decimal point AKA ',' ?
Why instead of a dot a comma (,) appears as the decimal separator when the instance locale is set to...

Servicenow has some indicator that browser settings may also have an impact

Some browsers use a comma (,) instead of a period (.) as decimal separator. - Support and Troublesho...

[rad2]

the data type on record producer is string field.

I have checked the sys property and script background. It shows the decimal separator as ','