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é

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.

Thanks , than i nowenough

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.