Unicode in varchar
in [Server Configuration]
|
Prev: SQL Server guest on an 8 core Hyper-V host
Next: SQL RS 2008 vs SQL RS 2008 R2 - streamIDs always nothing
From: bob123 on 7 Jun 2010 15:45 Hi, Can I have unicode in varchar/char or I have to use nvarchar /nchar ? Thanks in davance
From: Erland Sommarskog on 7 Jun 2010 17:45
bob123 (bob123(a)gmail.com) writes: > Can I have unicode in varchar/char > or I have to use nvarchar /nchar ? Varchar/char can only fit the 255 characters which are drawn from the code page your collation is tied to. To use the full set of Unicode you need to use nvarchar/nchar/ntext. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |