Devart Forums

Again I have a problem with the decimal separator (old forum post), but this time, the field type is set correctly. I use UniDac 6.0.1 now.

The setup is like this:

• the operating system is set to german locale (decimal separator is ',')
• the database used the English setup (expected decimal separator is '.')

in the uniloader the data-type of the column is set to ftExtended and in OnPutData I add an extended value
this results in the following error: I told MySQL to log all queries - as explained here and I can see that the data that is sent to the database is wrong (i.e. the ',' is used as decimal separator): and thus the MySQL database thinks there are too many columns

here is a simple delphi application that shows how to reproduce the error:
https://dl.dropboxusercontent.com/u/243 ... _MySQL.zip
the example also includes a text-file with the create script for the database table.

when I set the OS locale to English it works.

Please let me know if you can reproduce the issue (I can reproduce it on 2 different PCs).

Thank you for the information. The problem investigation is in progress. We will inform you when we have any results.

We have reproduced and fixed the issue. The fix will be included in the next UniDAC build.
We plan to release the new version of UniDAC with the fixed error within 2 weeks.

as a temporary workaround I installed UniDac 5.2.7

Today we have uploaded the new version UniDAC with fixed error to our website secure.devart.com.

verified that this is fixed in V6.1.6

If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.