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
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 How to change decimal format dot(.) to comma(,) in
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mast80864
Starting Member

India
4 Posts

Posted - 02/07/2013 :  06:04:29  Show Profile  Reply with Quote
Hi

We have production server in Iceland and it follows decimal format as "," example 12,23

But we have staging server with "en-US" settings in India and stores the value as 12.23

Now we need to change the format in staging and development machines to make same as production server to avoid issues in dev. environment.

Thanks
Mastan

Thanks
Mastan

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/07/2013 :  06:09:10  Show Profile  Reply with Quote
you dont need to do this change in table. This is a presentation requirement which should be done at your front end application. Application languages have set of formatting functions build in to perform these tasks

Trying to implement this in SQL is ugly as it would require datatype conversions which will cause unwanted overheads when you use this data for manipulations like sorting,comparison etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

mast80864
Starting Member

India
4 Posts

Posted - 02/07/2013 :  06:26:42  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

you dont need to do this change in table. This is a presentation requirement which should be done at your front end application. Application languages have set of formatting functions build in to perform these tasks

Trying to implement this in SQL is ugly as it would require datatype conversions which will cause unwanted overheads when you use this data for manipulations like sorting,comparison etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Thanks for your quick reply.

As of now we are doing it application level. But few issues we are not able to find until build moved to prodction since staging server is with "en-US" as defult and working perfect. To avoid these issue I want to change configuration of SQL SERVER Instance. I have tried it changing collation property(exactly production server database collation) of Database by recreating and restore DB option, still issue remains same.

Thanks
Mastan
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/07/2013 :  06:35:14  Show Profile  Reply with Quote
what are those issues? can you illustrate?
Changing collation wont change existing data. it will only affect newly added data.

So far as your base fields are numeric datatypes i don't think so you'll face any issues in comparing them regardless of their formats. The issue can happen only when you do processing outside of sql server ie in application or at front end

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jcarrallo
Starting Member

Spain
29 Posts

Posted - 07/17/2014 :  12:28:50  Show Profile  Reply with Quote
Hi,
Did you solve yoru problem?
I have exactly the same issue.
Many thanks,
Jay
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000