Formatting currency

Using Servoy to administrate the content of your website? Discuss all webrelated Servoy topics on this forum!

Formatting currency

Postby Gordon McLean » Fri Nov 23, 2012 2:52 pm

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 191
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Formatting currency

Postby boonstrj » Mon Nov 26, 2012 1:42 pm

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.
Jeroen Boonstra
2Serve-IT

Servoy version 5.2.13/6.1.x/7.1.0
boonstrj
 
Posts: 63
Joined: Mon Jan 07, 2008 11:49 am
Location: Netherlands

Re: Formatting currency

Postby rafig » Wed Jan 08, 2014 7:55 pm

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
Servoy Certified Developer
Image
rafig
 
Posts: 481
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK


Return to Web Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron