Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Changing the decimal symbol

Author  Topic 

Corobori
Posting Yak Master

105 Posts

Posted - 2005-09-14 : 22:19:24
I developped and application in ASP on my server which has the point as a decimal symbol. On my client's machine it is the comma. So I bumped into the situation shown below. How can I change, for that particular database the decimal symbol ?



jean-luc
www.corobori.com

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-19 : 04:58:30
what is the datatype of the value in the server
if it's decimal, then check your formats and how you process the value

are you related to picard?

quote:
Originally posted by Corobori

I developped and application in ASP on my server which has the point as a decimal symbol. On my client's machine it is the comma. So I bumped into the situation shown below. How can I change, for that particular database the decimal symbol ?



jean-luc
www.corobori.com



--------------------
keeping it simple...
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-19 : 05:51:11
this isn't a db thing.
it's a front end thing so you have to fix your app.
you just stumbled upon the great world of localization, which can be shitty...




Go with the flow & have fun! Else fight the flow
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-19 : 06:06:58
In ASP, use Format Funtion(or related to that) to format it the way you want

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-09-19 : 06:27:02
Change the client machine's

Start : Settings : Contrl panel : Regional and language options

to the appropriate settings for that "Locale"

Kristen
Go to Top of Page
   

- Advertisement -