SQL Server Specify Collation in Docker installation

zi8p0yeb 于 2023-05-16 发布在 Docker

关注(0)|答案(1)|浏览(236)

I've used this guide to install sqlserver on docker . However, the default collation it sets up is not the one I require. Is there a way to specify the desired collation during the installation process without having to change it afterwards? Thanks.

I don't know how to specify the collation I want: SQL_Latin1_General_Pref_CP850_CI_AS.

sql-server

来源：https://stackoverflow.com/questions/76230177/specify-collation-in-docker-installation

1条答案

按热度按时间

soat7uwm1#

SQL Server in Docker and Linux can be configured using environment variables . Use MSSQL_COLLATION to specify the desired collation:

sudo docker run -e "ACCEPT_EULA=Y" \
    -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>"
    -e "MSSQL_COLLATION=SQL_Latin1_General_Pref_CP850_CI_AS" \
    -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2022-latest

赞(0）回复(0）举报 2023-05-16

我来回答

SQL Server Specify Collation in Docker installation

1条答案

相关问题

热门标签

最新问答