INF: Data Types to Use for Currency Conversion Between European Nations (318610)

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 "scale" 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 "Precision, Scale, and Length."

For more information about conversion standards and requirements, click the following European Union Online Web site: 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.