List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 17 1999 1:30pm
Subject:Re: Decimal System
View as plain text  
Michael Widenius wrote:
> 
> >>>>> "Jochen" == Jochen Haeberle <listen@stripped> writes:
> 
> Jochen> Hi,
> Jochen> as I can see, mySQL internaly uses the (US) decimal-point. Is there
> Jochen> an easy way to swith to the (german) decimal-comma?
> 
> Hi!
> 
> With SQL, you have to use ','.  If not, you will get problems when
> using functions:
> 
> For example:
> 
> SELECT ABS(1,2)
> 
> Is this a call with one or two arguments ?
> 
> Regards,
> Monty

Hi Jochen

Of course you can use
REPLACE( number_column, '.', ',' )
for displaying your number with a ','.

Tschau
Christian

Thread
Decimal SystemJochen Haeberle16 Mar
  • Decimal SystemMichael Widenius16 Mar
  • Re: Decimal SystemChristian Mack17 Mar