Microsoft KB Archive/199834

= INF: SQL Server Support for the Euro Currency Symbol =

Article ID: 199834

Article Last Modified on 3/10/2006

-

APPLIES TO


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

-



This article was previously published under Q199834



SUMMARY
SQL Server support for the euro symbol depends on both the version of SQL Server and the operating system version you are using.

SQL Server 2000
For information on SQL Server 2000 support for the euro, see the MSDN article "International Features in Microsoft SQL Server 2000" at the following MSDN Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp

SQL Server 7.0
SQL Server 7.0 provides the same support for the euro currency symbol as for other special money characters such as the Japanese yen sign, the U.S. dollar sign, or the British pound sign.

SQL Server 6.5
SQL Server 6.5 Service Pack 5 (SP5) provides enhanced sort order definitions that include support for the euro currency symbol. SP5 is required for euro support.

Operating System Support
SQL Server 7.0 running on Microsoft Windows NT Server or Windows NT Workstation 4.0 requires Windows NT 4.0 Service Pack 4, which includes support for the euro character.

SQL Server 7.0 Desktop Edition runs on either Microsoft Windows 98 or Windows 95. Windows 98 supports the euro currency symbol, and has all the necessary fonts and built-in drivers to use the symbol, provided that your peripherals (such as printers) are designed to work with the euro. For Windows 95, you may need to install an updated font to enable support of the euro character. For more information, or to download the font updates, see the following Web site:

http://www.microsoft.com/windows/euro.asp

Operating system versions later than Windows NT 4.0 and Windows 98 support the euro with no additional modifications.

If the operating system supports the euro character, you can type the euro character symbol by using the keystroke ALT+0128 on the numeric keypad. Only certain fonts support the euro. For more information, see the following Web site:

http://www.microsoft.com/typography/faq/faq12.htm#w95



MORE INFORMATION
As of January 1, 1999, the euro is the official unit of currency for the European Union (EU) members. The ISO abbreviation for the euro is EUR (as compared to USD for U. S. dollars and FRF for French francs).

For more information, visit the Microsoft Euro Currency Resource Center at the following Web site:

http://www.microsoft.com/typography/eurosymbolfaq.mspx

Additional query words: smallmoney sp sp4 EU

Keywords: kbinfo KB199834

-

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

© Microsoft Corporation. All rights reserved.