October 6, 2012 at 3:57 am
All,
Does SQL 2012 supports UTF-8 or UTF-16 character set?
http://www.sqlservercentral.com/Forums/Topic732539-5-1.aspx
http://www.joelonsoftware.com/articles/Unicode.html%5B/url%5D
karthik
October 6, 2012 at 5:25 am
karthik M (10/6/2012)
Does SQL 2012 supports UTF-8 or UTF-16 character set?
SQL Server does not support UTF-8.
SQL Server does support aspects of UTF-16.
SQL Server natively supports UCS-2 which is a subset of UTF-16 (plane 0) and consists of all Unicode characters that can be represented using 2-bytes. You can store UCS-2 characters using the National types (NCHAR, NVARCHAR, NTEXT).
As of SQL 2012 you can also store some UTF-16 characters that require more than 2-bytes if you are using collations that support it. See section on Supplementary Characters: Collation and Unicode Support
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply