0

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é

3
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by TomW
0

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.

Edited by Ramesh S: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.