Re: decimal (european notation) dot to comma
Posted by:
Rick James
Date: April 10, 2010 12:38PM
The "proper" way is to store the number in DECIMAL format, but do the 'locale' formatting on the way in/out. That is, the application reading/writing the database should take responsibility for formatting, not the datastore.
That said; there might be a way to get what you are asking for, if you have a new enough version of MySQL (5.0.25 or 5.1.12):
http://dev.mysql.com/doc/refman/5.0/en/locale-support.html
Subject
Views
Written By
Posted
24033
April 07, 2010 06:35AM
Re: decimal (european notation) dot to comma
15167
April 10, 2010 12:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.