Decimal comma/point standard?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • JohnC

    Decimal comma/point standard?

    Hello people,

    I thought I was fairly proficient in websearching, but I haven't found
    a standard on how to
    encode numerical values in an XML file in a standard way. XML docs do
    specify character set encoding, but not a locale. So if I generate a
    data file, should I use decimal commas or points?

    Should I encode the locale in the document to ensure correct reading
    of the values? Is there
    some standard way to do this?

    This probably doesn't belong to the XML issue in itself, but I suspect
    this to be a fairly
    popular problem.

    Sorry if this is some FAQ - I haven't found it...

    John
  • Ron Peterson

    #2
    Re: Decimal comma/point standard?

    On Jun 5, 1:03 pm, JohnC <john.copp...@g mail.comwrote:
    Hello people,
    >
    I thought I was fairly proficient in websearching, but I haven't found
    a standard on how to
    encode numerical values in an XML file in a standard way. XML docs do
    specify character set encoding, but not a locale. So if I generate a
    data file, should I use decimal commas or points?
    Should I encode the locale in the document to ensure correct reading
    of the values? Is there
    some standard way to do this?
    You want to use <number-grouping-separatorand <decimal-separator>.

    --
    Ron


    Comment

    • Joseph J. Kesselman

      #3
      Re: Decimal comma/point standard?

      If you're using XML Schema to define your document's format, it has a
      standard for this.

      Comment

      • JohnC

        #4
        Re: Decimal comma/point standard?

        On Jun 5, 6:35 pm, Ron Peterson <r...@shell.cor e.comwrote:
        On Jun 5, 1:03 pm, JohnC <john.copp...@g mail.comwrote:
        >
        Hello people,
        >
        I thought I was fairly proficient in websearching, but I haven't found
        a standard on how to
        encode numerical values in an XML file in a standard way. XML docs do
        specify character set encoding, but not a locale. So if I generate a
        data file, should I use decimal commas or points?
        Should I encode the locale in the document to ensure correct reading
        of the values? Is there
        some standard way to do this?
        >
        You want to use <number-grouping-separatorand <decimal-separator>.
        Hi Rob, Thanks for the hint. I did a search for both names, and found
        _very_ few references.
        Is this really a standard, or was this specified by Oracle (the first
        references I found
        pointed there)? Is there any document on this?

        Thanks again.
        John

        Comment

        • JohnC

          #5
          Re: Decimal comma/point standard?

          On Jun 5, 7:24 pm, "Joseph J. Kesselman" <keshlam-nos...@comcast. net>
          wrote:
          If you're using XML Schema to define your document's format, it has a
          standard for this.
          Hi Joseph.
          Thanks for the reply. As far as I can see in the W3C Schema
          definition, things are simple -
          decimal numbers use decimal points, and no option seems to be present
          for allowing
          decimal commas. ( at least the regular expression in the w3c docs is
          definite about that).
          It _is_ the simplest solution.

          John


          Comment

          • Joseph J. Kesselman

            #6
            Re: Decimal comma/point standard?

            Thanks for the reply. As far as I can see in the W3C Schema
            definition, things are simple -
            decimal numbers use decimal points, and no option seems to be present
            for allowing
            decimal commas. ( at least the regular expression in the w3c docs is
            definite about that).
            It _is_ the simplest solution.
            For data interchange purposes, you want to pick *one* convention. No
            matter which one you pick it's going to disappoint someone, so the
            question winds up being which one's natural for the folks writing the
            spec. And since most spec authors are programmers and most programmers
            (and languages) already expect . as the decimal separator... More
            directly: There was an existing standard Schema could reference, so they
            referenced it rather than reinventing the wheel.

            Of course user interfaces are free to render the data in other ways. And
            you can use the other convention in XML if you're willing to be
            nonstandard or to simply treat it as text rather than expecting other
            tools to recognize it as the intended number.

            (Someday I should look up how , and . wound up with their functions
            being swapped in some cultures, and check which convention is actually
            older... just for historical interest.)

            Comment

            • Ron Peterson

              #7
              Re: Decimal comma/point standard?

              On Jun 5, 11:29 pm, JohnC <john.copp...@g mail.comwrote:
              On Jun 5, 6:35 pm, Ron Peterson <r...@shell.cor e.comwrote:
              You want to use <number-grouping-separatorand <decimal-separator>.
              Hi Rob, Thanks for the hint. I did a search for both names, and found
              _very_ few references.
              Is this really a standard, or was this specified by Oracle (the first
              references I found pointed there)? Is there any document on this?
              The Oracle document is where I got that information. I was thinking
              that entities would be a good approach but since Oracle has already
              proposed a solution using tags, that seemed to have less conflict with
              established practices.

              I noticed that France uses spaces for number grouping separators
              compared to Germany which uses commas. That makes the tagging method
              best for document appearance where the W3C Schema omitting the
              grouping separators is best for input to software.

              --
              Ron

              Comment

              • Peter Flynn

                #8
                Re: Decimal comma/point standard?

                Joseph J. Kesselman wrote:
                >Thanks for the reply. As far as I can see in the W3C Schema
                >definition, things are simple -
                >decimal numbers use decimal points, and no option seems to be present
                >for allowing
                >decimal commas. ( at least the regular expression in the w3c docs is
                >definite about that).
                >It _is_ the simplest solution.
                >
                For data interchange purposes, you want to pick *one* convention. No
                matter which one you pick it's going to disappoint someone, so the
                question winds up being which one's natural for the folks writing the
                spec. And since most spec authors are programmers and most programmers
                (and languages) already expect . as the decimal separator... More
                directly: There was an existing standard Schema could reference, so they
                referenced it rather than reinventing the wheel.
                >
                Of course user interfaces are free to render the data in other ways. And
                you can use the other convention in XML if you're willing to be
                nonstandard or to simply treat it as text rather than expecting other
                tools to recognize it as the intended number.
                >
                (Someday I should look up how , and . wound up with their functions
                being swapped in some cultures, and check which convention is actually
                older... just for historical interest.)
                There is a good thread about the pros and cons of choosing one format
                over others in the TEI discussions at:


                Joe is quite right: pick one, but *document* what you picked, so that
                those who come after you can understand it.

                ///Peter

                Comment

                Working...