Post reply

Decimal Separator

  • August 24, 2005 at 3:27 am

    #584516

    Chris after reading many of your post I would not have guessed that english was not your first language.

    Mike

  • August 24, 2005 at 7:11 am

    #584568

    DECLARE @1 float, @2 float, @DecTest float

    SET @1 = 1

    SET @2 = 2

    SET @DecTest = @1/@2

    SELECT Substring(CAST(@DecTest AS varchar),2,1) AS Separator

  • August 24, 2005 at 7:19 am

    #584571

    rich - the question was how to save values...

    chris - many moons ago i was in Sweden and i know they all speak excellent english - so pl. don't try and hide behind "English is not my first language" - you speak (type ?!) it much better than even the people who only speak English/American...

    btw:the only think i learnt from my Sweden trip was "jag talla inte svenska" (splng ??)







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 24, 2005 at 7:24 am

    #584572

    Maybe but it's still a good idea .

  • August 24, 2005 at 7:34 am

    #584575

    what is a good idea remi ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 24, 2005 at 7:35 am

    #584576

    His solution to find out what the decimal separator was.

  • August 24, 2005 at 8:00 am

    #584589

    Oh, I was answering this question:

    "How can I get the decimal separtor from SQL Server?"

    I should have read on a bit further

    I would have thought that the safest thing to do would be to homogenise the number before talking to SQL Server.  Perhaps format numbers to a standard locale on the client before they reach the web server ?

    Or have I missed the point ?

  • August 24, 2005 at 8:32 am

    #584607

    Thanks all for your input. 

    The SQL Server respected the Regional Settings Decimal separator when I did my testing.  When I changed to period, I could enter the float values like 56.67 and it displayed the same, when I changed the separator to comma, I could enter the float values like 56,67 and it displayed the same.

  • August 24, 2005 at 8:47 am

    #584617

    btw:the only think i learnt from my Sweden trip was "jag talla inte svenska" (splng ??)

    Almost. "talla" should be "talar".

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • August 24, 2005 at 8:51 am

    #584618

    thx. chris - guess it wasn't typed correctly..







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 24, 2005 at 8:54 am

    #584622

    Wohhh!!, nice setup .

  • August 24, 2005 at 9:03 am

    #584629

    thanks (I think) remi - not fair to use "setup" though...implies scheming and premeditation etc.. - none of which i'm guilty of...







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 24, 2005 at 9:05 am

    #584631

    How do you call it when actors start using lines to be able to throw in a joke a few lines later???

  • August 24, 2005 at 9:10 am

    #584637

    hmm - maybe a "setup" would be ok in that context!!!

    when I asked Chris for the spelling I genuinely wasn't sure if I had it right or not - I didn't deliberately "misspell" so I could throw in a punchline..







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 24, 2005 at 9:14 am

    #584642

    I'll withdraw my wohh!!! then. Still was a funny 15 minutes .

Viewing 15 posts - 16 through 30 (of 37 total)

You must be logged in to reply to this topic. Login to reply