centos 安装SQL Server设置默认语言与排序规则Chinese_PRC_CI_AS

偏执的太偏执、 2023-10-18 22:29 35阅读 0赞

## [linux / centos 安装SQL Server 2017 设置默认语言与排序规则Chinese\_PRC\_CI\_AS][linux _ centos _SQL Server 2017 _Chinese_PRC_CI_AS] ##

### 安装 ###

安装很简单参照官方教程  
[https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017][https_docs.microsoft.com_zh-cn_sql_linux_quickstart-install-connect-red-hat_view_sql-server-2017]

需要注意的是，如果安装时没有指定环境变量参数，会按默认设置安装，字符集会是拉丁字符集，默认语言是英语，此时国内用户可能需要进行另外设置。  
为了解决这个问题，我们可以通过预先设置环境变量来按照指定的字符集及本地语言等设置参数，这样的话无需安装后再进行配置。  
[https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-2017][https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-environment-variables_view_sql-server-2017]

MSSQL_LCID='2052' MSSQL_COLLATION='Chinese_PRC_CI_AS' /opt/mssql/bin/mssql-conf setup

环境变量说明：

*  MSSQL\_LCID 本地语言设置为简体中文
 *  MSSQL\_COLLATION 字符集为中文字符集

### 设置排序规则 ###

[https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017\#collation][https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-mssql-conf_view_sql-server-2017_collation]

systemctl stop mssql-server
    
    /opt/mssql/bin/mssql-conf set-collation 
    Chinese_PRC_CI_AS

### 设置默认语言 ###

可在SSMS的数据库高级选项中设置  
![aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTExNDkwMi8yMDE5MDIvMTExNDkwMi0yMDE5MDIxMjE3MTcwOTY4Ni0xODU5NTk0MjMyLnBuZw][]

也可通过命令设置  
[https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017\#lcid][https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-mssql-conf_view_sql-server-2017_lcid]

/opt/mssql/bin/mssql-conf set language.lcid 2052

拓展阅读：

单独对数据库设置排序规则

CREATE DATABASE dbname COLLATE Chinese_PRC_CI_AS
    ALTER DATABASE dbname COLLATE Chinese_PRC_CI_AS

查看支持的排序规则

SELECT Name from sys.fn_helpcollations()

参考  
[https://docs.microsoft.com/en-us/openspecs/windows\_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c][https_docs.microsoft.com_en-us_openspecs_windows_protocols_ms-lcid_a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c]  
[https://www.science.co.il/language/Locale-codes.php][https_www.science.co.il_language_Locale-codes.php]

转载请注明出处: cnblogs.com/wswind

[linux _ centos _SQL Server 2017 _Chinese_PRC_CI_AS]: https://www.cnblogs.com/wswind/p/10365571.html
[https_docs.microsoft.com_zh-cn_sql_linux_quickstart-install-connect-red-hat_view_sql-server-2017]: https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017
[https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-environment-variables_view_sql-server-2017]: https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-2017
[https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-mssql-conf_view_sql-server-2017_collation]: https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#collation
[aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTExNDkwMi8yMDE5MDIvMTExNDkwMi0yMDE5MDIxMjE3MTcwOTY4Ni0xODU5NTk0MjMyLnBuZw]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTExNDkwMi8yMDE5MDIvMTExNDkwMi0yMDE5MDIxMjE3MTcwOTY4Ni0xODU5NTk0MjMyLnBuZw
[https_docs.microsoft.com_zh-cn_sql_linux_sql-server-linux-configure-mssql-conf_view_sql-server-2017_lcid]: https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#lcid
[https_docs.microsoft.com_en-us_openspecs_windows_protocols_ms-lcid_a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c]: https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c
[https_www.science.co.il_language_Locale-codes.php]: https://www.science.co.il/language/Locale-codes.php