ubuntu16.04 安装sqlserver 2017

来源：互联网发布：狮王牙刷知乎编辑：程序博客网时间：2024/06/17 04:26

sqlserver 安装

https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-ubuntu

ubuntu 16.04 安装 sql server 驱动

https://docs.microsoft.com/zh-cn/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

sudo apt-get install unixodbc

sudo apt-get install unixodbc-dev

sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.listexitsudo apt-get updatesudo ACCEPT_EULA=Y apt-get install msodbcsql=13.0.1.0-1 mssql-tools=14.0.2.0-1sudo apt-get install unixodbc-dev-utf16 #this step is optional but recommended*#Create symlinks for toolsln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp

--修改数据库字符集

alter database DBName collate Chinese_PRC_CI_AS

阅读全文

0 0