I have a database set to one of the European countries locale settings. So the numeric Characters are , for decimal and . For group separator. I am able to execute an insert sql query with Insert into table values (‘12,12’) as well as insert into table values (12.12). I understand that oracle internally stores everything with the . Decimal character. I tested the above cases using dbeaver client and also my internal java application that executes a raw sql query.
the problem I have is, when I try to use a java program that takes input values from a Json input, and formulates the query, I am unable to insert values like 12.12 as the characters set for the database are comma for decimal and . For group separator. The values are correctly being parsed as BigDecimal but when the insert query is executed, I get an ORA001722 invalid number erroR.
my question is - what is the default behavior of oracle? If the number of characters are set to ,. does the database accept input values in both formats? Not sure if dbeaver is doing some conversion.
any help is greatly appreciated. Thanks.