Skip to main content


 

Symptoms


Input string is not in a correct format, when SQL columns are set to decimal. If changed to type 'Int', it works.
 

Diagnoses


Resolution sent due to lack of response.
 

Resolution

When creating a decimal column on a table with parameters (18,2) (maximum 18 characters on the left and 2 decimals on the right):

IF according to regional settings, the decimal separator is "." and the digit grouping symbol is ","
THEN on input 123.45 it will save as 123.45
BUT if the input is 123,45 it will save as 12345.00




 
Be the first to reply!

Reply