公司最近承接了一个项目，甲方现使用旧版SiteServer框架（以下简称“SiteCMS”）作为门户网站，使用的数据源是SQL Server。
现在需要对SiteCMS进行升级，在升级时数据库和数据库结构也需要同时更新，其中数据库要求从现在Windows Server服务器的SQL SERVER迁移到CentOS的Docker版SQL SERVER中以便可以Docker化统一管理（这个别人家的管理模式就不作深究了）。
为了确保工作万无一失，需要将数据备份还原到本地环境进行预演（已经过用户授权）。但是导入到测试环境时却出现中文乱码的情况。如下图所示：
本地环境模拟的镜像是“
mcr.microsoft.com/mssql/server:-latest”，这个镜像也将会在后面生产环境下使用。
先查询一下当前数据库的默认编码，如下图：
干过开发的都知道这个Latin1编码方式就是中文乱码的主要原因了。好了，现在问题也清晰了，就一句话“要怎样才能够在没有SQL SERVER管理器（Mac环境）的情况下修改Docker版SQL SERVER的编码规则呢？”，下面将详细讲讲这些走过的“弯路”。
按照网上的说法，首先先进入容器并切换到/opt/mssql/bin目录，如下所示：
yuanzhenhui@MacBook-Pro ~ % docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6ce7e5e399ba 314918ddaedf "/opt/mssql/bin/sqls…" 8 months ago Up hours :->/tcp mssql
yuanzhenhui@MacBook-Pro ~ % docker exec -it 6ce7e5e399ba bash
root@6ce7e5e399ba:/# cd /opt/mssql/bin
root@6ce7e5e399ba:/opt/mssql/bin# ls
compress-dump.sh crash-support-functions.sh generate-sql-dump.sh handle-crash.sh mssql-conf paldumper sqlservr
root@6ce7e5e399ba:/opt/mssql/bin# ls -al
total
drwxrwxr-x 2 root root Dec .
drwxrwxr-x 4 root root Dec ..
-rwxrwxr-x 1 root root Dec compress-dump.sh
-rwxrwxr-x 1 root root Dec crash-support-functions.sh
-rwxrwxr-x 1 root root Dec generate-sql-dump.sh
-rwxrwxr-x 1 root root Dec handle-crash.sh
-rwxrwxr-x 1 root root Dec mssql-conf
-rwxrwxr-x 1 root root Dec paldumper
-rwxrwxr-x 1 root root Dec sqlservr
root@6ce7e5e399ba:在该目录下有一个mssql-conf的可执行文件，然后通过“./mssql-conf set-collation”指令就能够设置你需要的编码，如下所示：
root@6ce7e5e399ba:/opt/mssql/bin# ./mssql-conf set-collation
Enter the collation: Chinese_PRC_CI_AS
Configuring SQL Server...
/opt/mssql/lib/mssql-conf/invokesqlservr.sh: line : sudo: command not found
root@6ce7e5e399ba:/opt/mssql/bin#(⊙o⊙)…这里说我没有sudo执行不了？好吧，那就装个sudo吧。还好镜像是用Ubuntu操作系统为基础的，用apt-get就能够轻松安装。如下所示：
root@6ce7e5e399ba:/opt/mssql/bin# apt-get update
Get:1 http://archive.ubuntu.com/ubuntu xenial InRelease [ kB]
Get:2 http://security.ubuntu.com/ubuntu xenial-security InRelease [ kB]
Get:3 https://packages.microsoft.com/ubuntu//prod xenial InRelease [ B]
Get:4 https://packages.microsoft.com/ubuntu//prod xenial/main amd64 Packages [ kB]
Get:5 http://security.ubuntu.com/ubuntu xenial-security/universe Sources [ kB]
Get:6 http://archive.ubuntu.com/ubuntu xenial-updates InRelease [ kB]
Get:7 http://archive.ubuntu.com/ubuntu xenial-backports InRelease [ kB]
Get:8 http://archive.ubuntu.com/ubuntu xenial/universe Sources [ kB]
Get:9 http://security.ubuntu.com/ubuntu xenial-security/main amd64 Packages [ kB]
Get: http://security.ubuntu.com/ubuntu xenial-security/restricted amd64 Packages [ kB]
Get: http://security.ubuntu.com/ubuntu xenial-security/universe amd64 Packages [ kB]
Get: http://security.ubuntu.com/ubuntu xenial-security/multiverse amd64 Packages [ B]
Get: http://archive.ubuntu.com/ubuntu xenial/main amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial/restricted amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial/universe amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial/multiverse amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-updates/universe Sources [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-updates/restricted amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-updates/multiverse amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-backports/main amd64 Packages [ kB]
Get: http://archive.ubuntu.com/ubuntu xenial-backports/universe amd64 Packages [ kB]
Fetched MB in 33s ( kB/s)
Reading package lists... Done
root@6ce7e5e399ba:/opt/mssql/bin# apt-get install sudo
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
sudo
0 upgraded, 1 newly installed, 0 to remove and not upgraded.
Need to get kB of archives.
After this operation, kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 sudo amd64 -0ubuntu1. [ kB]
Fetched kB in 1s ( kB/s)
debconf: delaying package configuration, since apt-utils is not installed
Selecting previously unselected package sudo.
(Reading database ... files and directories currently installed.)
Preparing to unpack .../sudo_1.-0ubuntu1.10_amd64.deb ...
Unpacking sudo (-0ubuntu1.) ...
Setting up sudo (-0ubuntu1.) ...
root@6ce7e5e399ba:/opt/mssql/bin#然后就又出现了另一个问题，如下图：
root@ff6113eba616:/opt/mssql/bin#sudo ./mssql-conf set-collation
Enter the collation: Chinese_PRC_CI_AS
Configuring SQL Server...
No passwd entry for user 'mssql'
root@ff6113eba616:mssql用户没有密码？按照这个提示又去网上找了一圈，下面就按照Stack Overflow里面的解答来进行了操作，如下所示：
root@a4b1b86ad87c:/# useradd mssql
root@a4b1b86ad87c:/# mkdir -p /var/opt/mssql
root@a4b1b86ad87c:/# chmod -R /var/opt/mssql
root@a4b1b86ad87c:/opt/mssql/bin# echo "Chinese_PRC_CI_AS" | /opt/mssql/bin/mssql-conf set-collation
Enter the collation: Configuring SQL Server...
:: Server Microsoft SQL Server (RTM-CU31) (KB5016884) - (X64)
Sep ::
Copyright (C) Microsoft Corporation
Enterprise Edition (-bit) on Linux (Ubuntu LTS)
:: Server UTC adjustment: 0: :: Server (c) Microsoft Corporation.
:: Server All rights reserved.
:: Server Server process ID is .
:: Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
:: Server Registry startup parameters:
-d /var/opt/mssql/data/master.mdf
-l /var/opt/mssql/data/mastlog.ldf
-e /var/opt/mssql/log/errorlog
:: Server Command Line Startup Parameters:
-q "Chinese_PRC_CI_AS"
:: Server Error: , Severity: , State: 1.
:: Server Error 5(Access is denied.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.呃...master.mdf文件没有访问权限？已经执行了chmod -R 的情况下居然没有权限？到了这一步实在没有办法，既然这样就回归本源不搞全局算了。
接着我这边就删除了容器并重新运行，先创建一个名为SiteCMS的数据库，接着直接对数据库进行编码的设定，如下图：
再之后重新导入数据
导入数据之后一切正常，ε=(′ο｀*)))唉早知道就不折腾了。