Regional settings and number format problems

Thread View: microsoft.public.data.odbc

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Alan Pettigrew Fri, 27 Oct 2000 13:58

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads