Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Add support for storing UTF-8 natively in SQL Server.

You can store Unicode data in SQL Server today, but only in UCS-2 encoding. In many environments, UTF-8 is the dominating encoding for Unicode data, and it is the default
encoding for XML documents.

Today UTF-8 applications must convert between UCS-2 and UTF-8 to retrieve and store
data in SQL Server, which adds complexity and overhead to applications.

Another issue is that for languages written in the Latin script, UTF-8 is a much more effective storage format, since most for characters in text, only one byte is needed.

6 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • JS-HdL commented  ·   ·  Flag as inappropriate

    This currently shows 0 votes, even though the converted data shows 109 upvotes. It is ridiculous that UTF-8 is *still* not supported in SSIS and SQL Server.

Feedback and Knowledge Base