Microsoft KB Archive/318610

= INF: Data Types to Use for Currency Conversion Between European Nations =

Article ID: 318610

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q318610



SUMMARY
This article describes the SQL Server data types that you can use when you perform currency conversion between European nations.



MORE INFORMATION
There are three SQL Server data types that you can use during currency conversion:

Money Data Type
The SQL Server money data type can store values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
 * You can use the money data type to store currency values.
 * You can store the final result in the SQL Server money data type.

Decimal and Numeric Data Types
The conversion rates require six significant figures (such as 0.765435). You must not round or truncate these conversion rates when you perform currency conversion. In SQL Server, the &quot;scale&quot; for the numeric and decimal data types is the number of digits to the right of the decimal point in a number. (For example 0.765435 has a scale of 6.)
 * To store conversion rates, use the decimal or numeric SQL Server data types with the appropriate scale.
 * For more information, view the SQL Server Books Online topic &quot;Precision, Scale, and Length.&quot;

For more information about conversion standards and requirements, click the following European Union Online Web site:

http://europa.eu.int

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Additional query words: euro foreign currency convert

Keywords: kbinfo KB318610

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.