I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

I want a culture insensitive decimal separator for Sql server

If there can be a culture insensitive format for dates (yyyymmdd) then why is there no such thing as a culture insensitive format for decimals?

I suggest a use of # or ~ instead of the decimal separator in update and insert scripts only.
And it would be allowed only in numeric/decimal/float datatypes.

so you could do:

create table t1 (MyDecimalCol decimal (16,3))
insert into t1 (MyDecimalCol)
select 123#456 union all
select 789#123

select MyDecimalCol 
from   t1
-- would give:
123.456 
789.123 -- or 123,456
789,123 -- depending on your locale

Wouldn't that be great?

I already suggested to Microsoft a culture neutral decimal separator a while back.

(Does anyone know the URL of the bug/feature request page on MS page? It's impossible to find it...)

Their answer was something like:
"Thanx for the suggestion. we'll look into it for the next verion of sql server."

So Katmai (SS2k7or8) better have this :)

 

UPDATE:

Thanx to Branko who pointed me to the MS feedback page in comments I found my submission of the problem.

You can look and vote for it here.

Print | posted on Tuesday, October 24, 2006 11:20 AM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: I want a culture insensitive decimal separator for Sql server

SS2k7or8 !?
More like SP3 ;)

But it still won't help the front-end users.
You have to teach them the search&replace trick in Excel anyhow!

PS.
You have my support!
10/24/2006 9:20 PM | rockmoose
Gravatar

# re: I want a culture insensitive decimal separator for Sql server

SP3 of SS2k5 or Katmai? :)

who cares about front end users :)))
10/25/2006 10:20 AM | Mladen
Gravatar

# Re: I want a culture insensitive decimal separator for Sql server


MSDN Product Feedback Center Migration Information Page

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220
10/25/2006 3:11 PM | Branko Hajdenkumer
Gravatar

# re: I want a culture insensitive decimal separator for Sql server

Thanx a lot Branko.
10/25/2006 3:15 PM | Mladen
Gravatar

# re: I want a culture insensitive decimal separator for Sql server

So the period isn't what some cultures use? Sorry for being ignorant. ;)
10/28/2006 2:02 AM | Tara
Gravatar

# re: I want a culture insensitive decimal separator for Sql server

I'll excuse you your ignorance. but just because it's you :)
10/28/2006 10:24 AM | Mladen
Gravatar

# re: I want a culture insensitive decimal separator for Sql server

yes you're exactly right.
i was talking about string to decimal conversion.

if not you can just use parameters like it's supposed to be and not worry about dots and/or decimals. :)
5/18/2007 10:12 PM | Mladen
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET