Currency delimiter showing as a , and not .

Question

0.00/5 (No votes)

See more:

I currently have a SQL-server 2012 running an application of mine

I am having one issue on my side and that is on my local machine i have currency value(rand) showing as R5000.00

I deployed my application to the server using Visual Studio 2010 and when i checked my currency values on the server it is showing as R5000,00

The delimeter is showing as the incorrect delimeter.

I have checked on the Regional settings and currency value delimeter shows .
SQL database shows the Value as R5000.00

What could i do to get the delimeter to show as my local machine?(i.e. R5000.00)

Posted 17-Mar-14 0:41am

isi19

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2014-03-17T01:02:00

Solution 1

What kind of application? Is the code running on the server??

Did you check the Region on the server? Wherever the code is running is where it's going to get the formatting information.

When you checked the value in SQL, were you running the query from your machine? That's where the formatting information is going to come from.

SQL Server does not store any "format" with numbers. Formatting is done by the client when it's displayed.

Posted 17-Mar-14 1:02am

Dave Kreskowiak

Comments

isi19 17-Mar-14 7:16am

So i tested running the application i coded on my local machine and then deployed it to a server. The server regional settings are the same as my local machine settings.

I have an older version of the application which is on the same server and that shows as my local machine.