SQL Server 2008中的排序规则 [英] collation in sql server 2008

问题描述

大家好，

目前，我正在从事从mysql到sql server 2008的数据迁移.

我无法在SQL Server中为
使用哪种类型的等效排序规则

Hi All,

Currently i am working in data migration from mysql to sql server 2008

i could not get what type of equivalent collation to be given in sql server for

collate utf8_swedish_ci<br />
collate utf8_unicode_ci

在mysql表中给出.

而且我还需要有关如何在sql server中设置字符集的帮助
.

which are given in mysql tables.

And also i need help regarding ,how to give characted set in sql server
.

"username" varchar(12) character set utf8 collate utf8_swedish_ci NOT NULL default '''',<br />
"house2" varchar(30) collate utf8_unicode_ci NOT NULL,

上一行的等效sql服务器代码是什么.

在此先感谢您的帮助.

what is the euivalent sql server code for the line above.

Your help will be greatly appreciated , thanks in advance.

推荐答案

我认为SQL Server中最接近的排序规则是Finnish_Swedish_CI_AS.由于您在MySql中使用瑞典语排序规则并且不区分大小写. SQL Server排序规则区分重音，因此如果使用不正确，则使用..._ AI

您可以使用此页面 http://msdn.microsoft.com/en-us/library/ms188046.aspx [ ^ ]进行匹配归类.


您可以在SQL Server中类似地定义排序规则，有关更多详细信息，请参见创建表 [ ^ ]和列的COLLATE关键字.

I think the closest collation in SQL Server is Finnish_Swedish_CI_AS. since you had swedish collation and case insensitive in MySql. The SQL Server collation is accent sensitive so if that''s not correct use ..._AI

You can use this page http://msdn.microsoft.com/en-us/library/ms188046.aspx[^] to match the collations.


You can define the collation similarly in SQL Server, for more details, see CREATE TABLE[^] and the COLLATE keyword for columns.

这篇关于SQL Server 2008中的排序规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！