Following are the SQL Server character set choices. The default is ISO 8859-1 (Latin 1 or ANSI).
ISO 8859-1 (Latin 1 or ANSI)
Code Page 850 (Multilingual)
Code Page 437 (U.S. English)
You must use the same character set on both the client and the server, or your results can be unpredictable. However, if your databases use only the first 128 characters of a character set (for example, if you don't use characters with diacritical marks), it makes no difference which character set you use because the first 128 characters are the same for all the character set choices.
The SQL Server character set choices are illustrated in the following figures and are described in the following sections. For additional information about character sets, refer to your manuals for Windows NT.