Member Avatar for 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é

  • 3 Contributors
  • 3 Replies
  • 103 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by TomW
Member Avatar for 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.

Edited by Ramesh S because: n/a
Member Avatar for dre-logics

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.