Hi,
I don't think this is really a Telerik issue, but I thought someone here might be able to offer some advice.
I am using telerik input on some web pages, and then changing the International settings on my browser to Dutch (or anything other than English really). This puts the euro symbol on the currency field as expected and is no problem. However, the thousands separator then becomes a period (.) and the decimal separator a comma (,). Again, exactly as expected. My issue however is when I then take that field and add it to my database, it does not hold it in what I might term a standard decimal format.
For example, entered on the web page is €0,50 - I want this to be stored internally and in the database as 0.50 so that I can perform standard math functions on it, but it is getting stored as 5.00
All my web pages as set to culture="auto" and display the correct currency and number formatting when I change the International settings.
Is there any standard method I should be using to convert values in International currency format into a "standard" decimal format for math operations?
David Penny
I don't think this is really a Telerik issue, but I thought someone here might be able to offer some advice.
I am using telerik input on some web pages, and then changing the International settings on my browser to Dutch (or anything other than English really). This puts the euro symbol on the currency field as expected and is no problem. However, the thousands separator then becomes a period (.) and the decimal separator a comma (,). Again, exactly as expected. My issue however is when I then take that field and add it to my database, it does not hold it in what I might term a standard decimal format.
For example, entered on the web page is €0,50 - I want this to be stored internally and in the database as 0.50 so that I can perform standard math functions on it, but it is getting stored as 5.00
All my web pages as set to culture="auto" and display the correct currency and number formatting when I change the International settings.
Is there any standard method I should be using to convert values in International currency format into a "standard" decimal format for math operations?
David Penny