regional settings for the website

Posted on 2009-02-23
Last Modified: 2012-05-06
Hello Experts,
I have a situation on the payment section of the website, we use third party payment gateway for processing orders online, for some reason the total amount on the cart changing from £34.99 to £3499 on the payment confirmation page.

I mean, through out the shopping basket until the final page before it gets redirected to
the payment site, the amount looks ok, soon it reaches to the payment site's confimration page its  changing to 3499. Strangely, this is happening only for those customers outside UK (problem now is for the EU user).

Someone advised that it could regional settings on the website, i have checked it is UK english.

I dont understand how users regional settings could have any impact on what money format I use on the website? On the site its in the following format


For this customer its getting change to £1999.

Any help/advice would greatly be appreciated.

Question by:newbie27
    LVL 12

    Accepted Solution

    The problem is that the regional settings should be based on the client regional settings.
    This means that your web site should change it's globalization settings based on the client.
    So I that I'm from Greece I could see let's say the dates in dd/mm/yyyy format and the decimal separator is the ","

    For u in England the date format should be mm/dd/yyyy and the decimal separator is the "."

    So the only thing you have to do is that on the begin request of each session to change the current thread (session) regional settings.

    If you are using a master page or an inheritable class (all your pages inherit from that class) it's quite easy to implement.

    From there on if you pass the numbers , dates etc in your store procedures with no further transformation (for example you don't replace the "," with ".") you will not have any further problem.
    LVL 8

    Author Comment

    hello and thanks for your input,
    if you are in the place where you have regional settings set to , instead of . as a decimal point

    please can you do me a favour of testing adding an item in the shopping cart and please go to the checkout details page and from
    there you would go to epdq page where you can see the total amount and when you click on purchase it will take you to the bank
    page where you will be shown the total price

    please can you confirm that both the prices are in decimal points and corret?

    thank you so much for your help
    LVL 8

    Author Comment

    please use the url below

    Open in new window

    LVL 12

    Expert Comment

    yes as i can see they are correct
    LVL 12

    Expert Comment

    I have checked it with en-us and Greek regional settings

    The first has a "." and the second has a ","
    LVL 8

    Author Comment

    and they both worked OK right?

    Thanks for doing this test for me !!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now