Get free live demo
Login
Cart
Home
Home
What is VisualCron?
Why choose VisualCron?
Our customers
Testimonials
Search
Social
Technology
Features
GENERAL
Features
Screenshots
API / SDK
Technology
ARCHITECTURE
Tasks
Triggers
Connections
AUTOMATION
General automation
Task Scheduler
FTP / SFTP/ SCP automation
Batch and exe automation
PowerShell automation
Cloud automation
Business Process Automation (BPA)
Encryption automation
SQL / database automation
Web macro recorder automation
Robotic Process Automation (RPA)
Managed File Transfer (MFT)
Extract Transform Load (ETL)
PDF automation and data extraction
XML automation and manipulation
Image automation and manipulation
Office 365, Excel and Macro Automation
Sharepoint automation
Archive automation
Virtual Machine Automation
Document scanning / OCR
ABOUT VISUALCRON
VisualCron is an
Automation
,
Integration
and
Task Scheduling Tool
for
Windows
.
Get free live demo
Download
Download
Change log
Requirements
Get free live demo
Order
Order
License guide
Choosing the right license
Basic vs Pro edition comparison
Cart
Get price quote
Use PO / get invoice
Return policy
Company information
Reseller information
Partners
Get free live demo
Support
Community forum
Documentation
Video tutorials
Maintenance & priority support
Contact us
Get free live demo
My pages
Start
My profile
My contacts
My licenses
My cloud Servers
My orders
Blog
Site map
Community forum
Support
Community forum
Please note that VisualCron support is not actively monitoring this community forum. Please use our
contact page
for contacting the VisualCron support directly.
Welcome Guest! To enable all features please
Login
or
Register
.
×
Forum
Search
Login
Register
Login
×
User Name or E-Mail Address:
Password:
Caps Lock is on
Remember me
×
Forum
Support
General problem solving
SQL-Server Number format
SQL-Server Number format
Previous Topic
Next Topic
Tools
Email this topic
Watch this topic
Print this topic
jasmin.dizdarevic
Paid support
Topic Starter
2017-02-23T08:51:27Z
#1
Hi,
when doing a query against SQL-Server there is an unwanted conversion of numeric values.
"" "2,9665" "J" "0" "N" "" "" "15100,0000" "15.01.2012"
should be
"" "2.9665" "J" "0" "N" "" "" "15100.0000" "15.01.2012"
"Convert data types" is not checked in connection properties. Also not in ODBC-Settings.
Other ODBC-Tools are working well.
Locale of the VC-Server is: Germat(AT)
VC-Version: 8.2.5 beta
Edited by moderator
2017-02-24T09:02:41Z
|
Reason: VC-Version added
Quick Reply
Reply
View All Posts by User
Sponsor
Forum information
Wanna join the discussion?!
Login to your Forum forum account
or Register a new forum account
×
thomas
Free support
2017-02-23T09:39:49Z
#2
I don't think this has to do with types. It's just the formatting of numbers (regional settings) that is different on the db server vs VC server. I doubt this is something that VC controls. As you said, the local on your VC server is German, so the numbers will be displayed with comma.
Quick Reply
Reply
View All Posts by User
jasmin.dizdarevic
Paid support
Topic Starter
2017-02-23T09:55:17Z
#3
You're right. It's not just with SQL-Server - it's a general behavior.
The question is, if this is handy. In my case I'm exporting some db records to a file which will be processed by another program. The raw format for numbers in almost every database is to use . as decimal. Now, I have to deal with german locales, because the output has been transformed by "someone". If it's done by VC, an option would be great to output the data as they arrive from database (but of course as valid CSV -
http://www.visualcron.co....aspx?g=posts&t=7087
)
Quick Reply
Reply
View All Posts by User
thomas
Free support
2017-02-23T10:08:29Z
#4
Ok I understand. I don't think this is possible, but I may be wrong about this. This is how it works in my mind:
VC receives data from SQL server. The number are of type int, float whatever. When it
displays
the result, the numbers are formatted (ie they are displayed as string type). If you want VC to display it using the setting from the Db server, then VC would have to know what the regional settings were on that server. This is not information it has access to. VC almost certainly uses the regional settings on the server it is installed.
As a quick fix, you can format the numbers in SQL. It's not pretty but it works:
Quick Reply
Reply
View All Posts by User
al355
No customer
2017-02-23T10:37:24Z
#5
Yes we mentioned this, we need something around this as well. The CSV spec allows for double quotes " around entities. So for example
ABC,123,"123,456,789",Test
Quick Reply
Reply
View All Posts by User
jasmin.dizdarevic
Paid support
Topic Starter
2017-02-23T11:40:35Z
#6
I see the problem now:
Console.WriteLine((2.5234).ToString());
//output: 2,25234
Console.WriteLine((2.5234).ToString(CultureInfo.InvariantCulture));
//output: 2.25234
Default behavior in .NET when casting to string is to output decimal number locale specific. With InvariantCultere the output would be ok - for me and my requirement.
@al355: Did you notice that the csv thing was solved in 8.2.5 beta?
Quick Reply
Reply
View All Posts by User
al355
No customer
2017-02-24T11:46:57Z
#7
We are not expecting any solution for now, this is a feature for the future
Quick Reply
Reply
View All Posts by User
Similar Topics
Number of rows returned SQL task
(
General problem solving
) by
Support
2015-10-19T11:55:12Z
Format SQL Output in email text Message
(
General problem solving
) by
klewis10367
2013-10-21T17:27:33Z
copy large number of files with file list from SQL
(
Feature requests
) by
ErikC
2009-07-22T17:54:07Z
count number of files in a directory
(
General problem solving
) by
Gary_W
2020-03-27T19:15:53Z
Limiting number of active jobs
(
General problem solving
) by
barefootguru
2019-05-23T03:53:30Z
Users browsing this topic
Guest
Forum
Support
General problem solving
SQL-Server Number format
© VisualCron
Scroll to Top