H2数据库 - 小数分隔符 [英] H2 database - decimal separator

问题描述

我正在尝试从Oracle导入一些数据到H2。我有一个列类型为NUMBER（15,3）的表，并为该列插入脚本值为13253,124。

I'm trying to import some data from Oracle to H2. I have a table with column type NUMBER(15,3) and insert script with value '13253,124' for that column.

问题是H2无法识别逗号小数分隔符并且无法插入行...

Problem is, H2 cannot recognize comma as decimal separator and fails to insert the line...

有什么方法可以说H2使用逗号作为十进制分隔符而不是点？

Is there any way to say to H2 "use comma as decimal separator instead of dot"?

感谢

推荐答案

您需要使用圆点， code> PreparedStatement 与 setBigDecimal 。

You need to use a dot, or, even better use a PreparedStatement with setBigDecimal.

在Oracle中工作，使用默认设置。我可能是错的，但我认为它不工作与任何通用的数据库。测试用例（与Oracle使用 SQLFiddle ）：

What you try doesn't work in Oracle either, with the default settings. I could be wrong, but I think it doesn't work with any common database. Test case (using SQLFiddle with Oracle):

create table test(x number(15,3)); 

insert into test values('13253,124');
-> invalid number : insert into test values('13253,124')

insert into test values(13253,124);
-> too many values : insert into test values(13253,124)

这篇关于H2数据库 - 小数分隔符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！