INF: SQL Server Support for the Euro Currency Symbol

ID: Q199834

The information in this article applies to:

Microsoft SQL Server versions 6.5, 7.0

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 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. For more information, visit the following Web site:

http://www.eu.microsoft.com/technet/topics/Euro/feature/euro_view9796EN.htm

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, go to the following location:

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

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, visit the following 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:

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

Additional query words: smallmoney sp sp4 EU

Keywords :
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbinfo