Summary

Microsoft SQL Server 2000 is a powerful technology for supporting international operations and environments. At the heart of its multilingual features is the Unicode support available in SQL Server 2000. Through data types, SQL Server can store international, language-specific characters and support different clients that are running various character encodings at the same time.

Non-Unicode text is stored in the char, varchar,and text data types.Unicode data is stored in the nchar, nvarchar, and ntext data types in SQL Server 7 and SQL 2000. The datetime and smalldatetime data types represent various date and time values.

In addition to data types, collation is another important component in sorting and comparing multilingual data, whether Unicode or non-Unicode. In SQL Server 2000, a single, consistent model was designed to handle both Unicode and non-Unicode sorts. There are 40 languages that support 17 collation suffixes, producing a total of 680 Windows collations.

Among the guidelines that you should follow with SQL Server are to always use Unicode data types and to standardize the site collation where possible. You should also try to deploy a Unicode server and client if you can, consider storage space and performance, and delimit identifiers for objects in system tables.



Microsoft Corporation - Developing International Software
Developing International Software
ISBN: 0735615837
EAN: 2147483647
Year: 2003
Pages: 198

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net