Professional Web Applications Themes

Currency Symbols,, - Microsoft SQL / MS SQL Server

Hi all.. I have an application used by people from differents countries, the matters is that I need to display on reports money simbols according to the currency of each country, i.e Users From Japan Customer A S10 Customer B S20 Where S is the simbol and should be Yen simbol Users From USA Customer A S10 Customer B S20 Where S is the simbol and should be Dollar simbol Any idea? TIA Julio....

  1. #1

    Default Currency Symbols,,

    Hi all..

    I have an application used by people from differents countries, the matters
    is that I need to display on reports money simbols according to the
    currency of each country, i.e

    Users From Japan

    Customer A S10
    Customer B S20

    Where S is the simbol and should be Yen simbol



    Users From USA
    Customer A S10
    Customer B S20

    Where S is the simbol and should be Dollar simbol


    Any idea?

    TIA
    Julio.




    Julio Guest

  2. #2

    Default Re: Currency Symbols,,

    Julio,

    Values of type money in SQL Server are simply numbers, and
    don't include a currency symbol. Your reporting tool should be
    able to display numerical values according to the users regional
    settings.

    If not, the Books Online article "Using Monetary Data" gives
    the Unicode values for each supported language symbol, and
    between that and the value of LANGUAGE, you should
    be able to simply put the language symbol into any query you
    wish.

    -- Steve Kass
    -- Drew University
    -- Ref: 9FEFE734-FDEC-4BFD-9AA6-6026E616F95C

    Julio Gonzalez wrote:
     

    Steve Guest

  3. #3

    Default Re: Currency Symbols,,

    > I have an application used by people from differents countries, the
    matters 

    Use your client application to convert the numerical value to a regional
    string. SQL Server only stores the numeric portion; it is up to the display
    / rendering tool to present the data to the user in a specific format.


    Aaron Guest

Similar Threads

  1. Currency type?
    By Murray in forum Dreamweaver AppDev
    Replies: 17
    Last Post: July 18th, 01:53 PM
  2. Currency Converter
    By maflu in forum PHP Development
    Replies: 4
    Last Post: November 21st, 01:15 PM
  3. currency formatting
    By ian in forum PHP Development
    Replies: 0
    Last Post: October 20th, 03:40 PM
  4. Currency problems
    By Nick in forum Microsoft Access
    Replies: 4
    Last Post: September 4th, 04:22 AM
  5. Format Currency in ASP?
    By jason in forum ASP
    Replies: 3
    Last Post: August 25th, 10:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139