Loading float/decimal values with LoadFromDataset of UniLoader
Posted: Tue 07 Jul 2020 07:29
Hi!
I'm trying to load data from dataset (MS SQL) with UniLoader.LoadFromDataSet() method to MySQL table. It seems there is a problem with decimal values. When it encounters values like 123,4 in MS SQL column (type float) it reports that "column count does not match value count". Number of fields in dataset and in destination table is the same. I assume this is because of the comma in value. In destination table column type is decimal.
How can I workaround this?
I'm trying to load data from dataset (MS SQL) with UniLoader.LoadFromDataSet() method to MySQL table. It seems there is a problem with decimal values. When it encounters values like 123,4 in MS SQL column (type float) it reports that "column count does not match value count". Number of fields in dataset and in destination table is the same. I assume this is because of the comma in value. In destination table column type is decimal.
How can I workaround this?