Regional settings and number format problems

Article View: microsoft.public.data.odbc

Article #4

Back to microsoft.public.data.odbc Previous Next

From: Alan Pettigrew
Date: Fri, 27 Oct 2000 13:58

22 lines
1775 bytes

We have a SQL server database running on NT4, and a C++Builder program
accessing it via ODBC.

If the ODBC connection is set to 'Use regional settings when outputting
currency...' then the number output from the program is wrong.

Any numbers > 3 digits (the regional setting for grouping numbers) are
truncated in the data received by the program, so presumably it is ODBC.

I suspect that the processing sees "1,000" and stops at the "," as it isn't
numeric.

Changing the grouping to 0 digits or clearing the 'Use regional' flag fix
the problem.

Is there a fix for this?  It allows users to corrupt the data, and the
program has no control over what it receives.

Thanks for any help.

Alan
mailto:alan.pettigrew@fox-europe.com

Technical Details

Message-ID: <39f989f5$1_1@nnrp1.news.uk.psi.net>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!news.tele.dk!193.190.198.17!newsfeeds.belnet.be!news.belnet.be!psinet-eu-nl!psiuk-p4!uknet!psiuk-n!nnrp1.news.uk.psi.net!193.122.15.2

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f40d,28d1649a4da0a75f,start
X-Google-Attributes: gid10f40d,public
X-Google-Thread: fcacf,28d1649a4da0a75f,start
X-Google-Attributes: gidfcacf,public
X-Google-ArrivalTime: 2000-10-27 07:01:48 PST
From: "Alan Pettigrew" <alan.pettigrew@nospam.com>
Newsgroups: microsoft.public.data.odbc,borland.public.cppbuilder
Subject: Regional settings and number format problems
Date: Fri, 27 Oct 2000 14:58:06 +0100
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 193.122.15.2
Message-ID: <39f989f5$1_1@nnrp1.news.uk.psi.net>
X-Trace: 27 Oct 2000 14:58:13 GMT, 193.122.15.2
X-Original-NNTP-Posting-Host: nnrp1.news.uk.psi.net
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!news.tele.dk!193.190.198.17!newsfeeds.belnet.be!news.belnet.be!psinet-eu-nl!psiuk-p4!uknet!psiuk-n!nnrp1.news.uk.psi.net!193.122.15.2