INF: SQL Server Support for the Euro Currency Symbol (199834)



The information in this article applies to:

  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)

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:

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

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:

Modification Type:MajorLast Reviewed:3/10/2006
Keywords:kbinfo KB199834