Formatting currency

[Gordon McLean]

I am having problems getting a currency formatted filed to display with £ instead we are getting $ in the web client. The intention is to deliver the app via the web client, but right now I am being asked why they cant have a format

£1,000.00

I am using the following formatting at field level:
¤#.00|#.00

In web client this returns $ not the local £. In the server I have the locale.default set as:
en,GB

If anyone has ideas I am very interested to know what I am doing wrong.

As a by the by the database format set by Servoy when adding fileds is float, should this be decimal or numeric ? and is there a way to change Servoy to default numbers as either if these ?

best
Gordon

[boonstrj]

The used locale in web-client depends on settings in the webbrowser, only if the webbrowser doesn't supply a locale the server default is used.

[rafig]

Hi Gordon,
I know this is a very old thread, but did you solve this?
I was just trying to see how one of my smart client solutions worked on the web and noticed the same issue (with me testing on my Mac from Servoy Developer to Safari) and came across the issue.

Thanks

Rafi