w2k SP2.
chcp returns 866
Accsess-2000
A table stores numbers in currency format
When outputting thsese numbers into an HTML page using ASP and Personal Web
Server and viewing it in IE6 all the numbers greater than 999 (i.e. those
where digit group separator might be applied), have letter "B" inserted
together with a space as a group separator. For instance, 3000.00 is shown
as 3B 000.00
In regional settings the digit group separater set to nothing (empty field)
In Accsess all the numbers look normal.
I managed to sort this out by explicitly disabling digit grouping using
built-in ASP function FormatNumber().
Yet I still am curious where this "B" cames from.
On another computer it works fine without FormatNumber(). Therefore the
problem seems to be somewhere in w2k settings.
> w2k SP2.
> chcp returns 866
[quoted text clipped - 13 lines]
> On another computer it works fine without FormatNumber(). Therefore the
> problem seems to be somewhere in w2k settings.
This has little to do with number format.
Russian uses non breaking space (U+00A0) as thousand separator (an I guess
you are on Russian system because of the 866). This is the result of number
formatting, and it is correct.
Non-breaking space as UTF-8 is 'C2 A0' (bytes), which, when interpreted
as 1252, gives cyrillic capital letter Ve (U+0412) (which looks like an
uppercase B), followed by non-breakig space.
So you are seeing a UTF-8 page as 1251.
To confirm this is the case, force the browser to UTF-8:
Firefox: View -> Character Encoding -> Unicode (UTF-8)
IE6: View -> Encoding -> Unicode (UTF-8)
Is the result looks ok, try adding the proper meta tag in the head section of
your HTML:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

Signature
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
aa - 28 Jan 2007 21:31 GMT
Mihai, Many thanks for the most irrefragable answer
aa - 28 Jan 2007 21:31 GMT
Is it OK if I post your comment to a NG dealing with ASP - other people
might find it useful?
Mihai N. - 28 Jan 2007 22:24 GMT
> Is it OK if I post your comment to a NG dealing with ASP - other people
> might find it useful?
As long as you keep the author info, no problem :-)
Whatever I post in a public newsgroup/web site is public info,
you don't even need to ask :-)

Signature
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email