"Unicode Data
Traditional non-Unicode data types in Microsoft(r) SQL Server(tm) 2000
allow the use of characters that are defined by a particular character
set. A character set is chosen during SQL Server Setup and cannot be
changed. Using Unicode data types, a column can store any character
defined by the Unicode Standard, which includes all of the characters
defined in the various character sets. Unicode data types take twice as
much storage space as non-Unicode data types.
Unicode data is stored using the nchar, nvarchar, and ntext data types
in SQL Server. Use these data types for columns that store characters
from more than one character set. Use nvarchar when a column's entries
vary in the number of Unicode characters (up to 4,000) they contain. Use
nchar when every entry for a column has the same fixed length (up to
4,000 Unicode characters). Use ntext when any entry for a column is
longer than 4,000 Unicode characters.
Note The SQL Server Unicode data types are based on the National
Character data types in the SQL-92 standard. SQL-92 uses the prefix
character n to identify these data types and values.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
