From: Christian Mack
Date: March 17 1999 1:30pm
Subject: Re: Decimal System
List-Archive: http://lists.mysql.com/mysql/417
Message-Id: <36EFAE74.77997D97@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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