linux安装sqlserver_linux sqlserver set-collation

作者：秋刀鱼在做梦 | 2024-07-15 03:27:08

踩

linux sqlserver set-collation

刚踩完坑，马上过来记下！！！

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
add-apt-repository “$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)”
apt-get update
apt-get install -y mssql-server
apt-get -f install
sudo /opt/mssql/bin/mssql-conf setup
systemctl stop mssql-server
sudo /opt/mssql/bin/mssql-conf set-collation
Chinese_PRC_CI_AS
systemctl enable mssql-server && systemctl start mssql-server

到这里就安装完啦！！！
接下来使用navicat连接sqlserver
通过sql语句建一个库

USE [master]
GO

/****** Object: Database [meihua] Script Date: 2022/1/10 19:44:49 ******/
CREATE DATABASE [meihua_test]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’meihua’, FILENAME = N’/var/opt/mssql/data/meihua.ndf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：【wpsshop博客】