Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Missing a decimal point >Thread Next - Re: Missing a decimal point Re: Missing a decimal pointTo: NULL Date: 2/4/2005 10:11:00 AM Hi,
Thanks for your comments. Basically (Simplified) it looks like this (VB
sample):
Dim dom As New MSXML2.DOMDocument
Dim val As Double
'the xmlfile is <value>2.25</value>
dom.Load "C:\Code\Misc\xmlparser\value.xml"
val = CDbl(dom.Text) 'this returns 225 if the Decimal separator is (,)
and the group separator is (.)
To me the question is is there any way in a pure XML to specify the type
and maybe the used decimal separator...
"Martin Honnen" wrote:
>
>
> Ivan wrote:
>
>
> > Recently I had some problems with MSXML misinterpretting numbers with
> > floating points - when I want to save something like 0.123456 it saves it as
> > 123456.
> > It has to do with the locale - some European locales use "," as decimal
> > separator instead of period "." and this is when the problem happens - looks
> > like msxml only understands the "." so if we switch back to English locale
> > the problem is gone.
> > Is there any other way to fix this problem besides changing the locale back
> > to US English? Some of our customers are not willing to do this.
>
> Can you show us exactly in what way you use MSXML then that problems
> occurs? Are you using DOM or XSLT? Show us the relevant code, relevant
> XML input and output.
> I am guessing that you have for instance
> <data>0.123456</data>
> in some XML input but you need to show what you do then with MSXML when
> you say "saves it as 12345".
>
> --
>
> Martin Honnen
> http://JavaScript.FAQTs.com/
>
| ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
