如何在SQL Server数据库中使用UTF-8排序规则? [英] How to Use UTF-8 Collation in SQL Server database?

问题描述

我已使用UTF8将数据库从mysql迁移到SQL Server(策略)，即原始的mysql数据库.

I've migrated a database from mysql to SQL Server (politics), original mysql database using UTF8.

现在，我阅读了 https://dba.stackexchange. com/questions/7346/sql-server-2005-2008-utf-8-collat​​ion-charset SQL Server 2008不支持utf8，这是个玩笑吗?

Now I read https://dba.stackexchange.com/questions/7346/sql-server-2005-2008-utf-8-collation-charset that SQL Server 2008 doesn't support utf8, is this a joke?

SQL Server托管多个数据库，大多数数据库都是拉丁编码的.由于迁移的数据库是用于Web发布的，因此我想保持utf8编码.我错过了什么吗?还是需要在应用程序级别进行增减?

The SQL Server hosts multiple databases, mostly Latin-encoded. Since the migrated db is intended for web publishing, I want to keep the utf8-encoding. Have I missed something or do I need to enc/dec at application level?

推荐答案

否！这不是在开玩笑.

在这里看看: http://msdn.microsoft.com/en -us/library/ms186939.aspx

字符数据类型为固定长度，nchar或 可变长度，nvarchar，Unicode数据，并使用UNICODE UCS-2 字符集.

Character data types that are either fixed-length, nchar, or variable-length, nvarchar, Unicode data and use the UNICODE UCS-2 character set.

并且也在此处: http://en.wikipedia.org/wiki/UTF-16

较早的UCS-2(2字节通用字符集)是类似的 在2.0版的UTF-16中已取代的字符编码 1996年7月成为Unicode标准.

The older UCS-2 (2-byte Universal Character Set) is a similar character encoding that was superseded by UTF-16 in version 2.0 of the Unicode standard in July 1996.

这篇关于如何在SQL Server数据库中使用UTF-8排序规则?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！