BUG: Money Values Incorrectly Use Thousand Separator

  - Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

Under Microsoft Windows NT if the thousand separator is set to null or a space, then the dbconvert function will generate a " instead of a space or a null whenever converting a money value to a string.

NOTE: The 1000 separator is set using the International Applet in the NT Control Panel.

For example,

   SELECT $1234567.80

   1"234"567.80

For example,

   SELECT $1234567.80

   1
   234
   567.80

CAUSE

Specifying a blank or null separator through Control Panel causes Windows NT to respectively store "" and " " in the registry. DB-Library, in turn, only considers the first character.

Under MS-DOS and OS/2, DB-Library incorrectly handles a blank or null thousand separator.

WORKAROUND

For Windows NT, changing the registry entry \current user\control panel\international\sthousand to space works as expected. Setting it to null causes the separator to default to a comma.

Under MS-DOS and OS/2, do not use a null separator.

STATUS

Microsoft has confirmed this to be a problem in DB-Library version 4.20.50. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.