Home / server / Questions / 880269
Accepted
Ondrej Tucny
Asked: 2017-10-26 09:17:13 +0800 CST

UNICODE version supported by SQL Server 2016

  • 772

What is the Unicode standard version supported by SQL Server 2016? (I'm specifically interested in this version. However, information for 2014 or 2017 is welcome as well.)

I can't find this information in Technet / MSDN. The only information I was able to find, is this blog post that states Unicode versions up until SQL Server 2012.

sql-server

1 Answers

  1. Best Answer

    Was looking at this myself today. Turns out I can do Unicode 9 on SQL 2016 without issues.

    CREATE TABLE [Test].[dbo].[?](
    [?] [nchar](10) NULL
) ON [PRIMARY]

    Works perfectly. So I even can do this:

    SELECT ? FROM dbo.? WHERE ? = ?

    I wasn't able to test Unicode 10 since my OS (2012 R2 for my test server doesn't support it). SQL Server never struggled, doing it with SSMS was trickier, so I did it via Powershell.

    • 1