MySQL table settings decimal comma or point

[dre-logics]

I use MYSQL 5.0
I have a table with a field named ArticlePrice.
The content of the ArticlePrice field looks like this 10.50
My question is: is there an environment variable or system variable MYSQL who can change the locale currency in to Europe setting
.
So that the content of the ArticlePrice field looks like this 10,50

Thank,

André

[Ramesh S]

There is no setting available to display the number to a specific currency format. It is the matter of display in the tool that you are using to view the data.

However you can format the number in SELECT query or format the number in the user interface(like web pages) whaterver currency format you want.

[dre-logics]

Thanks , than i nowenough

[TomW]

Using CultureInfo you can display the numeric values to specific formats.

Formatting Numeric Data for a Specific Culture