Storage comma instead of dot in numeric types

Sergio Ramos · #1 (**permalink**) 02-14-07, 09:58

I´d like to know how to storage in MySQL numeric fields with comma intead of dot. Ex.: 1.000,00 instead of 1,000.00

r937 · #2 (**permalink**) 02-14-07, 10:37

you cannot store them that way, but you can display them that way...

Code:

select replace(
       replace(
       replace(format(yourcolumn,2),'.','~')
                                   ,',','.')
                                   ,'~',',') as foo
  from ...

healdem · #3 (**permalink**) 02-14-07, 10:53

.....thats a presentation issue

so if you are using raw SQL as your front end (say int heMySQL command line, or a query browser, then Rudy's solution is correct, alternatively you should be using whatever your front end is to format the data as you expect. Normally this sort of issue would be covered by the client workstations internationalisation settings.

Internet Services

Web Development

Digital Marketing

Consumer Tech