SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Changing the decimal symbol
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Corobori
Posting Yak Master

Chile
105 Posts

Posted - 09/14/2005 :  22:19:24  Show Profile  Visit Corobori's Homepage
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 09/19/2005 :  04:58:30  Show Profile  Send jen a Yahoo! Message
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

Slovenia
11751 Posts

Posted - 09/19/2005 :  05:51:11  Show Profile  Visit spirit1's Homepage
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

India
22760 Posts

Posted - 09/19/2005 :  06:06:58  Show Profile  Send madhivanan a Yahoo! Message
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

United Kingdom
22403 Posts

Posted - 09/19/2005 :  06:27:02  Show Profile
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000